Hi guys
Compliments of the new season.
We have a database running on Oracle 817 and there are around 4 to 5
applications running there. Initially the platform was Windows NT,
service pack 6. Everything was working fine, now recently, the O/S was
upgraded to Windows 2000. Then our problems
Hallo,
I have this sql,
SELECT * FROM varukorgtmp
where varukorgid= 120 That makes the result of this testfile.xls
(See attached file: start.xls)
There are two values in EAN-field, which are the same
23324614 in row 2 and 3
Now I want in an sql script to check out which are the duplicates
Hi guys
Compliments of the new season.
We have a database running on Oracle 817 and there are around 4 to 5
applications running there. Initially the platform was Windows NT,
service pack 6. Everything was working fine, now recently, the O/S was
upgraded to Windows 2000. Then our problems
Hi all
Ok all indications are that I need the JAVA modules installed.
Client does not like the idea of installing the java modules now on a live
system,
So will be doing this using Unix shell scripting.
Thx for the help, will try all out on the sand box server for myself and
then ensure all
Hi Jackson Dumas,
Have check the virtual memory (paging space) of the OS ?
Because sometimes it's related. And, how big memory that you used in your
server ?
Thank's
Bernardus Deddy Hoeydiono.
-Original Message-
Dumas
Sent: Wednesday, January 08, 2003 2:59 PM
To: Multiple recipients
Use Excel.
K. ;O)
-Original Message-
Sent: 07 January 2003 16:29
To: Multiple recipients of list ORACLE-L
Hi
How to avoid FULL TABLE SCAN?
Thx
-seema
_
MSN 8 with e-mail virus protection service: 2 months FREE*
Jackson Dumas,
Maybe we need to know whether your os upgrade caused oracle upgrade? I
mean if you did oracle exp/imp, patch, migration etc? I mean if there is anything
else is changed ?
Make a statspack and check what is the oracle doing. That will be
helpful:)
Hi Rolland,
Here the script for check the the duplicate row as per your email.
select ean from table_name where varutyp=3 group y ean
having count(ean) 1;
For deleting the duplicate rows :
delete table_name where ean in
(select ean from table_name group by ean
Title: How to create two db-links within one schema when global_names=true?
Hi!
Is there a way to create two db-links within one schema when global_names=true?
e.g.
create public database link DB1 connect to hr identified by pwd_hr using 'DB1';
create public database link DB1 (???)
Ave !
How about something like:
delete from varukorgtmp where varutyp = 3 and EAN =
(select EAN from varukorgtmp a where rowid !=
(select min(rowid) from varukorgtmp b where a.EAN = b.EAN));
Should work, but not tested :)
Br.Jorma
Do you mean to move as many statements inside of
the loop to outside of the
loop as possible? If yes, I'll pursue that.
Try to use INSERT ... SELECT ... (or UPDATE (in-line view)) wherever possible. SQL
was designed as a language with set-handling capabilities, most people seem to have
Roland,
select *
from varukorgtmp v
where exists (select ''
from varukorgtmp v2
where v2.ean = v.ean
and v2.rowid != v.rowid)
will show duplicates of ean
select *
from varukorgtmp v
where exists (select ''
from varukorgtmp v2
I always keep global_names set to FALSE but I think that if you name your database
links say DB1.hr and DB1.shipping it should work.
- Original Message -
From: Daiminger, Helmut
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Wed, 08 Jan 2003 01:44:25
I think you are new to the list.
All '_' parameters given as a solution without a warning that their use can
be dangerous, are meant as fun and nothing else.
Regards
Naveen
-Original Message-
Sent: Wednesday, January 08, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L
Is it good
Title: How to create two db-links within one schema when global_names=true?
You can create as many dblinks as you want provided
that the dblink name is the same as the global name of the database you connect
to.
In your example:
Create public database link HR connect to HR identified by
Look up the details of 'connection qualifiers'.
create public database link DB1@HR
connect to hr identified by pwd_hr using 'DB1';
create public database link DB1@SHIP
connect to shipping identified by pwd_shipping using 'DB1';
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Large national known company in New York City, New York needs an Oracle DBA
with SAP R/3
(Including tax tools) experience to join their corporate IT staff.
*PLEASE Do Not send your resume for this position UNLESS you already live in
the
Greater New York City area and have the skills outlined
Title: AW: How to create two db-links within one schema when global_names=tr
Hi Jonathan,
thanks for your reply.
The deal is that you can't use DB1@HR and DB1@SHIP if you are using global_names=true; the link name has to be the same than the global database name.
But what do
Helmut
Try this
create public database link DB1@hr connect to hr identified by pwd_hr
using 'DB1';
create public database link DB1@shipping (???) connect to shipping
identified by pwd_shipping using 'DB1';
You should then be able to use them as follows -
select * from
Title: RE: Database/system Crashing
No sorry... just a simple 2 disk development Unix box...
Sun Solaris 8
-Original Message-From: Burke, William F (Bill)
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 5:09
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Dennis,
I think that the article is correct that girls and teens are sensitive to
the geek stigma factor.Even in our 10-year-old Girl Scout troop, the
girls are already concerned about their images and not being too dorky.
We have many more girls vote for activities involving animals and
David
The problem is that HR and SHIPPING are the same database.
I wrote to him offline saying that he needs to create a user that have
access to both schemas and use one dblink only.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: AW: How to create two db-links within one schema when global_names=tr
Hi,
Where
these two, V$SYSTEM_PARAMETER, V$PARAMETER dynamic view are
differs?
Both
of them looks the samein structure and data as
well.
Anybody have any idea.
Nirmal.
-Original Message-From:
Title: RE: FULL TABLE SCAN?
Don't use tables, just use views ... view scans are better and faster, because by definition views are just definitions, so it will be faster. Memory scans are faster than disk access by a factor of (say) 10,000 (if you believe manufacturer's claims).
8:)
Raj
I think that within the population of women in IT, the number of female
Oracle DBAs is increasing. However, in general, the number of women
entering IT is decreasing. That is, the number of women who are
encouraged to become DBAs or developers or network admins or sys admins
is decreasing.
I've
I like geek girls!!
Dave
-Original Message-
Sent: Wednesday, January 08, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
Dennis,
I think that the article is correct that girls and teens are sensitive to
the geek stigma factor.Even in our 10-year-old Girl Scout troop, the
You
might check with Gaja to get "Buffer Ca$h Hit Ratio" displayed inthe tool he is working on. Oracle can always
issuea "bug fix" to whoever complains... ;)
-
Kirti
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 07, 2003 6:46
PMTo:
Title: RE: FW: IOUG-A
Mogens,
Pity you ... you are still using Hit Ratios ... time for you to buy new books ... g
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and
Very good point, Jared.
We experienced similar fiasco when installing a vendor supplied appl called JourneyX
(for tracking how and where we spend our time at work). After it was released for use,
some set up in the Appl caused a flood of e-mails to all employees. Took almost a
full day to
Dorky rules :)
It's sad that there isn't a requirement for the science/math activities
in the Girl Scouts. The problem is that society in general doesn't show
images of science as being cool and definitely doesn't show images of
women as scientists. Or at least, not enough images.
--- [EMAIL
Title: Create Mat View uses DEFAULT TABLESPACE for temp segments?
This is 8.1.7.4 on AIX 4.3.3. When I try to create a materialized view in
the specified tablespace, I hit the following error. Is this a behavior of
the create materialized view statement, to create temp segments in the user's
Title: AW: How to create two db-links within one schema when global_names=tr
In
their scope...
View
v$parameter shows current settings for a session.
View
v$system_parameter shows system wide parameter settings.
See below:
SQL select name, value from
v$system_parameter where name like
hi nice to see ur mail...and one thing
VB stands for visual basic...
Then if it is so,can u help me for the following two
questions...
Regards,
N.Prakash.
---
question one :
--
Hi guys,
Hope all are
Title: Message
ummm...I just
truncated all of the system tables in a new database (that's not good). No
backups yet. Anyway to recover from this or do I have to recreate the
database?
Thanks,
Tom
Terrian
Title: RE: Orawomen
Well, it's been a while since I was in college (1999) but I always felt singled out in a class. Some teachers, that were as old as the hills, truly felt that women should not be in science and did not hesitate to say so. Other teachers could not keep their eyes off my legs
Dan,
Look
at the TO_DATE function. You can easily change your procedure to the
following:
PROCEDURE
set_expire_date ( p_user_group_id IN NUMBER DEFAULT
NULL,
p_product_id IN VARCHAR2 DEFAULT
NULL,
p_expire_date IN VARCHAR2 DEFAULT NULL)IS
local_date
date;
== added this
BEGIN
Just asking .. I'm told that the number of Americans (by which I mean kids
born in the States) entering technical fields of all types is declining.
Could the decline of the number of women in IT entering IT be a part of that
trend?
For that matter, I wasn't really called on much in school (and
Cherie, Rachel - Thanks for sharing your viewpoint.
Brian - I think you are correct that kids today get very little
encouragement to study hard subjects like sciences. I find this ironic given
the fact that we have an incredibly technological society. I think this is a
cumulative product of our
Yechiel
There is a well hidden feature that allows you to put an extra
'connect_descriptor' on the end of a database link name for exactly this
purpose. Take a look at
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elem
ents10a.htm#27762
for a description.
HTH
David
I'd venture a guess that if it were a requirement there would be fewer girl
scouts. Girls join girl scouts to have fun, and I think that they would
perceive any requirement as an impediment to their fun, especially something
dorky.
I agree that it is an image thing. We need some cool female
I have found that men are fascinated, not intimidated
by techie girls. We can offer them fashion advice as
well as hardware recommendations.
Saira
--- Farnsworth, Dave
[EMAIL PROTECTED] wrote:
I like geek girls!!
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Title: AW: How to create two db-links within one schema when global_names=tr
Nirmal,
When the instance starts up both have same
information. If you set a session's value using ALTER SESSION SET
someparameter = somenewvalue then the newvalue is shown in
V$PARAMETER but not in
ok
-Original Message-
Sent: Wednesday, January 08, 2003 10:34 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
you have to recreate, there is no way to recover from the truncate, nothing is
written to the rollbacks when do you that.
Unless, of course, you want to spend umpty-ump dollars
you have to recreate, there is no way to recover from the truncate,
nothing is written to the rollbacks when do you that.
Unless, of course, you want to spend umpty-ump dollars on Oracle's Data
Unloader. But if it's a new database, it's probably simpler to
recreate.
--- Terrian, Tom
So do I.. and married one... she is a Math major (with Masters) and a CS Diploma.
:)
- Kirti
-Original Message-
Sent: Wednesday, January 08, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L
I like geek girls!!
Dave
-Original Message-
Sent: Wednesday, January 08, 2003
No aliens foreign or outer space kind.
snip another job position
Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Joseph S Testa
INET: [EMAIL PROTECTED]
Fat City
Title: RE: Orawomen
My youngest is in high school and is the only woman taking mechanic drawing. She is the best in the class. The instructor was berating the boys that a 'girl' was beating them until my daughter told the instructor to keep gender out of it! She also wanted to join the Chess
Title: Create Mat View uses DEFAULT TABLESPACE for temp segments?
Perfectly normal. Temporary objects are used for more than just sorting.
They are used when creating indexes, tables, mviews and
certain other objects and operations (such as some parallel operations).
The temp segment in this
Back
in my college days, we had a game called Quarters. The idea was to bounce a
quarter off the table an into a glass of beer. The owner of the glass then had
to drink the glass to retrieve the quarter. Thus, a HIGH cash hit ratio directly
translated to more drinking. However, it must be
It is the science, not the scientists which attracts people. This year we will begin
building a coherent light source which will pulse every few femtoseconds. This is
fast enough that we to see chemical reactions taking place; i.e. bonds between
molecules forming or breaking. That's pretty
And the images that they DO show are of single women who's job is their life
and they are socked away 16 hours a day with no social life... just what
every girl looking to her future wants to think awaits her.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from
think kind of showing females and males as well practical needs and applications of
structured thinking an analysis (even for houskeeping ...sorry) could be better than
showing them off (like: ought better do smthng else than calculus).
blame the consumer oriented industry and society -
Title: RE: Orawomen
I have
encouraged and pushed science on my daughter and son. My daughter started
college this year and wants to go into the biological sciences. I
periodically have been a guest teacher at our local schools to teach some
physics and am amazed at the lack of interest in
I recall that people were looking for UNIX/DBA admin books, I did a
search and came across some interesting reading
Have a look, This is a riot!
http://carcino.gen.nz/images/index.php/54de433e/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
INET:
cool female scientists: Grace Hopper, Sally Ride, Ellen Ochoa, Margaret
Mead, Rachel Carmichael, Marie Curie, Mae Jemison, Maria Mitchell
where's that spotlight? ;)
-Original Message-
Sent: Wednesday, January 08, 2003 8:34 AM
To: Multiple recipients of list ORACLE-L
I'd venture a guess
I have had the pleasure of working with 2 female DBA's at my company. I
have to say they were both the best DBA's the company has had. Both were
very technical, very detailed, and very dedicated. The fact that they were
both attractive didn't hurt either. One majored in mathamatics and had a 4
We have a .so C library file containing C routines (Cfunctions.so) which we
invoke via the external procedure listener.
This file works fine with 32-bit 8.1.7 Oracle
However we have now installed 64-bit 9i (9.2.0.1) and we now get the error,
using exactly the same .so file
ORA-06520: PL/SQL:
Gene,
First of all, the out of space failure may be perfectly normal. Even if you
do a 200M table import there are several other recursive statements that
generate a lot of undo information, including but not limited to segment
expansion, extent creation, partition operation process, etc. Some
Title: Message
No
backup = No recovery!
-Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08,
2003 7:19 AMTo: Multiple recipients of list
ORACLE-LSubject: Truncate system tables.
ummm...I just
truncated all
Hi
That seems to be more of a question for a VB newsgroup. Sorry that I can't
help here.
Stefan
-Ursprüngliche Nachricht-
Von: guess who [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 8. Januar 2003 15:04
An: Multiple recipients of list ORACLE-L
Betreff: Re: Re: Out of oracle VB
List,
Oracle 8.1.7 rel 3
OS OpenVMS 7.3-1
I am using RMAN to backup my database and have run out of disk
space.
Talking to the sysadmin I learned an interesting fact about RMAN and
disk allocation.
When I use the set limit channel d1 kbytes=300; to limit the
size of the file created
Have you checked on 'connection qualifiers' in
the manual as I suggested in my reply ?
DB1 is the database name and database link name -
but I have used HR and SHIP as the connection qualifiers
to identify two separate paths to the same database.
Note the appearance of two '@' signs when using
John - I'm going to go out on a limb here, but should you be linking 64-bit
routines with the 64-bit Oracle? Just a thought.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, January 08, 2003 9:09 AM
To: Multiple recipients of list
Title: Message
Tom,
wait. laughing.
ok. I'm better now.
since
you havn't really lost anything (just time), just re-create
it.
I bet
you won't do THAT again!
Tom
Mercadante Oracle Certified
Professional
-Original Message-From: Terrian, Tom (Contractor)
Title: RE: Orawomen
Having taught IT classes (and taken some lately) at college level... it
amazed me that, in a class of 20 undergrad students, only one was female (that
was in a Database class as well as in one on C programming). I noticed
that we were definite minority in 94 when I was
Brown-nosing a bit eh? Rachel may be a fine DBA, but a scientist, I think not. I
also have a problem with social scientists A hard science bias I not only admit, but
proclaim. You forgot to mention Heddy Lamar. Few would call her dorky. Her work on
frequency-hopping communications is
Title: AW: How to create two db-links within one schema when global_names=tr
I
believe that the distinction is that V$Parameter is at the session level, where
v$system_parameter is at the instance level.
Thus,
if you issue an alter session set shared_pool= 1024000, the setting in
My wife is a teacher...
Parents by and large don't care much about their children's education. The
public education service is primarily a daycare for working parents. It
varies of course, but when there is a snow storm and schools have to close
for the day, we don't hear my child will miss out
Tom,
There is no respectable way of saying it but you screwed up.
Welcome to the club of the sharp learning curve of remembrance.
Recreate and perform a cold backup immediately.
Ron
[EMAIL PROTECTED] 01/08/03 09:18AM
ummm...I just truncated all of the system tables in a new database
I respectfully disagree, you can recover from a truncate. Restore a backup,
recover to immediately before the truncate. You cannot rollback a truncate.
The database will have to be recreated because there is not a backup. If the
tables had been deleted, then committed, the effect would be the
I've seen behavior like this on AIX, but it shrinks the file back down after
the backup is complete.
I've not seen this on NT that I recall, I'll have to test it.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
Author of several books you can find on
Now when a young woman in the computer field is considering
becoming an Oracle DBA, a quick scan of the bookshelves turns up
Rachel's name. So hear that Rachel -- you're a role model, so you
must
write more books!
Oh I pity the poor young girl who makes me her role model. Besides, my
Recompile the 'C' module. The calling formats from the 64Bit external
procedure handler don't line up with the 32Bit binary .so file.
At least that's my SWAG at it =8-)
Jeff Herrick
On Wed, 8 Jan 2003, John Dunn wrote:
We have a .so C library file containing C routines (Cfunctions.so) which
Title: RE: Orawomen
I will agree to some extent. But I have TRIED to get my daughter on
the computers, into math and science, interested in anything technology... she
tells me that Computers are geeky (she's 8). She is my militant little
feminist and into sports and precision jump rope... I
Hi Tom,
Nothing I would feel comfortable with. Be happy that it was new. I would
recomend
trashing it and starting over.
John
Terrian, Tom (Contractor) (DAASC) wrote:
Message
ummm...I
just truncated all of the system tables in a new database (that's not good).
No
Title: Message
Ok...
I've got a copy of 9iAS 9.0.3 for NT I'm wanting to install, but I'll be darned
if I can find an install guide anywhere
I've
looked on OTN and can find an install guide for a SUN and AIX, but no NT. Anyone
have any ideas if such a beast
exists
and if so where?
I particularly like the website name itself
very cute!
--- Bob Metelsky [EMAIL PROTECTED] wrote:
I recall that people were looking for UNIX/DBA admin books, I did a
search and came across some interesting reading
Have a look, This is a riot!
Title: RE: wrong ELF class: ELFCLASS32
You probably have to relink ... in the 64bit mode I think.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect
I am by no means a scientist.
I'd add Marlene Theriault to that list and the women of this list as
well
--- STEVE OLLIG [EMAIL PROTECTED] wrote:
cool female scientists: Grace Hopper, Sally Ride, Ellen Ochoa,
Margaret
Mead, Rachel Carmichael, Marie Curie, Mae Jemison, Maria Mitchell
I prefer it to be Mary showing me her light source ever few femtoseconds.
Dave
-Original Message-
Sent: Wednesday, January 08, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
It is the science, not the scientists which attracts people. This year we will begin
Title: RE: Orawomen
Lisa,
Nursing is no place for a woman; if you
thinkDBA'ing is stressful, you ain't seen nothingyet My wife
is an RN and, while it may nobe scientific, I attribute our difficulty in
conceiving and miscarriage to job stress working on an understaffed hospital
floor. That
Robin,
Yes, there is already declining enrollment in Girl Scouts in general and in
the older age ranges as the kids get into Middle School or Junior High.
The Girl Scouts organization is very sensitive to having activities be
driven by what the girls want to do, not just what the leaders think
Gene,
Are you using Automatic (System Managed) UNDO? or the traditional
Rollback segment method?
If you are using Automatic UNDO, you should have more than 2
segments in the UNDO tablespace. The number of segments initially created is
the function of processes and the minimum I
This is all so true... Sounds like my wife must teach at the same school.
It is a regular occurrence for me to photocopy lessons at my place of work
because all of the copiers at the school are broken or are out ink. One
thing that makes me really mad is that the teachers are all restricted to
Title: RE: Orawomen
Maybe
so, Dave, but I have seen physics demonstrations that had entire auditoriums of
kids (yes, high school and junior high kids, both girls and boys) in awe.
They did the regular holding-the-fire-extinguisher-while-sitting-on-a-skateboard
demonstration along with
Title: Message
System
tables means tables owned by "SYSTEM" or owned by "SYS", just making
sure?
Waleed
-Original Message-From: Terrian, Tom (Contractor)
(DAASC) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08,
2003 9:19 AMTo: Multiple recipients of list
The real key to this issue is not making it a GS requirement, but in getting parents off their butts and being parents. I continually work with my kids, especially my daughters (ages 17,16,12) to be individuals and go for what they like and find interesting. Forget the pop culture and fashion
Title: RE: Orawomen
I
don't know about you, but the first time I took a logic course it was in
university... It seems to me it would be fun for high school students to
take newspaper or magazine articles (Teen magazine comes to mind) and pull them
apart to show that statement B doesn't
Title: Create Mat View uses DEFAULT TABLESPACE for temp segments?
Yes, but these operations should be using the TARGET
tablespace, and not the DEFAULT
tablespace to create the TEMP segments,
correct? I know when I rebuild indexes
at least, that's the case.
-Original Message-From:
Title: RE: Re: Out of oracle VB question
I am not allowed to say this publicly but you better be running 10i Beta for this, this is NOT SUPPORTED in 9i or earlier versions (I am just lucky).
alter session set progamming_language='VB.NET'
/
alter session set
Ian,
The fact that more girls graduate high school than boys and that many
women earn degrees does not debunk the girls are not called upon
statement. I didn't say that happened in all classes, certainly in the
history classes and English classes I took the girls were called on as
much if not
very technical, very detailed, and very dedicated. The fact that
they were both attractive didn't hurt either. One majored in math
I'm about to start a flame war here, I just know it.
WHY does it matter to mention the attractiveness of the female DBAs?
When I talk about someone I work with,
Title: RE: RMAN and disk usage info
I've seen this on my Windows system. It creates one huge file for each channel to disk and the file size shrinks a bit after backup completion. I never tried to determine what is controlling the initial file sizes (heck, it's working and someone is
I can relate to this. I have two sons and both have told me that based on what
my work life seems like they would never pursue an IT career. Things could
change over time, of course, as the reality of making a living sets in. My
undergraduate and graduate degrees have absolutely nothing to do
Robert,
The OTn about 9.0.3 says to use the 9.0.2 docs except for J2EE
installation. The NT doc's for 9.0.2 are at the URL
http://otn.oracle.com/docs/products/ias/doc_library/90200win_otn/docs.htm
Hope this helps,
Ron
[EMAIL PROTECTED] 01/08/03 10:54AM
Ok... I've got a copy of 9iAS 9.0.3 for
Jackson,
Was the OS actually upgraded to win2k, or was it reinstalled?
because Win2k UPG != Win2k installed
The concensus among SA's seems to be that upgrading from
NT to Win2k is not a good thing. Our SA's refuse to do it.
Jared
Jackson Dumas [EMAIL PROTECTED]
Sent by: [EMAIL
What's amazing to me is that I, with my AD in Data-freaking-Processing, was
making more than twice what my lovely wife was with her Masters in
Communicative Disorders. Just plain wrong. Another reason why she's chosen
not to work in that field anymore. A shame that her talents in the field
are
Ok, try this one. It's a little smarter. :)
create or replace function df1
( date_in varchar2 )
return date
is
x_date exception;
pragma exception_init(x_date, -1830);
v_source_date_format varchar2(20) := '-mm-dd';
begin
if owa_pattern.match(date_in,'^\d{4}-\d{2}-\d{2}')
I think you would be a perfect role model.
April Wells
Oracle DBA
Great spirits have always encountered violent opposition from mediocre minds
-- Albert Einstein
-Original Message-
Sent: Wednesday, January 08, 2003 10:50 AM
To: Multiple recipients of list ORACLE-L
Now when a
Title: Message
Install guide - install guide! we don'need no
stinkin install guide! :)
did
you look on the Cd itself? maybe you can find it
there?
Tom Mercadante Oracle Certified Professional
-Original Message-From: Freeman Robert - IL
[mailto:[]]Sent: Wednesday,
January
1 - 100 of 186 matches
Mail list logo