RE: SEQ#, DUAL and Oracle literacy
Okay, I can't resist. If you read the history of databases, sometimes it seems that Bill Gates is the Edison of our day. Others may have had technically superior products, but they are mere historical footnotes. Answers to trivia questions. And while I personally feel Oracle is technically superior to its competitors, past and present, Larry is no shrinking violet publicity-wise. The book "The Difference Between God and Larry Ellison" relates how Ingres was developing a distributed capability. Larry simply announced SQL*Star. No development. His developers first learned about their new project from the media announcement. When Ingres unveiled their product, the reporters said "oh, Ingress has on just like Oracle does". And who recalls Ingres today? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 26, 2002 8:23 AM To: Multiple recipients of list ORACLE-L Tesla kicked Edison's ass. Edison was one who stole most of the items he was credited for. Jared, I totally agree with you. Tesla is a very interesting and very misunderstood scientist. Dave -Original Message- Sent: Tuesday, June 25, 2002 2:04 PM To: Multiple recipients of list ORACLE-L > Economize synapses... paste and execute in SQL*Plus. Sorry Steve, I can't do that. Two great figures from the 19th/20th centuries were Nicola Tesla and Thomas Edison, with Tesla having a clear edge in the intelligence department, while Edison was from the PT Barnum School of Business. Given an irregularly shaped object and asked to determine its volume, Edison would promptly drill a hole in it, get a container with lines measuring of the volume of liquid it contained, fill the container and thereby determine the objects volume. While Edison would be farting around, Tesla would measure the object, write down the measurements, then proceed to calculate the volume of the object. Tesla's methods scaled. Edison's didn't We have Tesla to thank for our electric power, not Edison, due to his thinking ability. He also invented radio. When Marconi built on Tesla's work and tried to patent it, he found Tesla had already visited the patent office. As Tesla is my idol, conserving synapses is something I find inherantly distasteful. Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/25/2002 08:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: SEQ#, DUAL and Oracle literacy > I had to ponder this for a few seconds. Economize synapses... paste and execute in SQL*Plus. -Original Message- Sent: Saturday, June 22, 2002 12:53 PM To: Multiple recipients of list ORACLE-L LOL! I had to ponder this for a few seconds. Good one Steve. Jared On Tuesday 18 June 2002 14:23, Orr, Steve wrote: > Here's a performance tuning query to help identify the problem: > > SELECT column_name "The problem is the..." > FROMdba_tab_columns > WHERE owner='SYS' > AND table_name = 'DUAL' > / > > :-) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'Lis
RE: SEQ#, DUAL and Oracle literacy
Tesla kicked Edison's ass. Edison was one who stole most of the items he was credited
for. Jared, I totally agree with you. Tesla is a very interesting and very
misunderstood scientist.
Dave
-Original Message-
Sent: Tuesday, June 25, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
> Economize synapses... paste and execute in SQL*Plus.
Sorry Steve, I can't do that.
Two great figures from the 19th/20th centuries were Nicola Tesla
and Thomas Edison, with Tesla having a clear edge in the intelligence
department, while Edison was from the PT Barnum School of Business.
Given an irregularly shaped object and asked to determine its volume,
Edison would promptly drill a hole in it, get a container with
lines measuring of the volume of liquid it contained, fill the
container and thereby determine the objects volume.
While Edison would be farting around, Tesla would measure the object,
write down the measurements, then proceed to calculate the volume
of the object.
Tesla's methods scaled. Edison's didn't
We have Tesla to thank for our electric power, not Edison, due to
his thinking ability. He also invented radio. When Marconi built on
Tesla's work and tried to patent it, he found Tesla had already
visited the patent office.
As Tesla is my idol, conserving synapses is something I find
inherantly distasteful.
Jared
"Orr, Steve" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/25/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: SEQ#, DUAL and Oracle literacy
> I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.
-Original Message-
Sent: Saturday, June 22, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L
LOL! I had to ponder this for a few seconds.
Good one Steve.
Jared
On Tuesday 18 June 2002 14:23, Orr, Steve wrote:
> Here's a performance tuning query to help identify the problem:
>
> SELECT column_name "The problem is the..."
> FROMdba_tab_columns
> WHERE owner='SYS'
> AND table_name = 'DUAL'
> /
>
> :-)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
...Jared snaps, er synapse, on off topic. :-) Tesla... isn't he a descendant of Rambaldi? ;-) If you want to get "religious" about human "intelligence" check this out: http://www.followersoframbaldi.org/index.html ;-) >conserving synapses is something I find inherantly distasteful. And I thought you liked good scotch. :-) BTW, I couldn't agree with you more on your Edison/Tesla observation. Tesla was amazing. OK, struggling to get my brain back on topic now... -Original Message- Sent: Tuesday, June 25, 2002 11:57 AM To: [EMAIL PROTECTED] Cc: Orr, Steve Importance: High > Economize synapses... paste and execute in SQL*Plus. Sorry Steve, I can't do that. Two great figures from the 19th/20th centuries were Nicola Tesla and Thomas Edison, with Tesla having a clear edge in the intelligence department, while Edison was from the PT Barnum School of Business. Given an irregularly shaped object and asked to determine its volume, Edison would promptly drill a hole in it, get a container with lines measuring of the volume of liquid it contained, fill the container and thereby determine the objects volume. While Edison would be farting around, Tesla would measure the object, write down the measurements, then proceed to calculate the volume of the object. Tesla's methods scaled. Edison's didn't We have Tesla to thank for our electric power, not Edison, due to his thinking ability. He also invented radio. When Marconi built on Tesla's work and tried to patent it, he found Tesla had already visited the patent office. As Tesla is my idol, conserving synapses is something I find inherantly distasteful. Jared "Orr, Steve" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 06/25/2002 08:03 AM Please respond to ORACLE-L > I had to ponder this for a few seconds. Economize synapses... paste and execute in SQL*Plus. -Original Message- Sent: Saturday, June 22, 2002 12:53 PM To: Multiple recipients of list ORACLE-L LOL! I had to ponder this for a few seconds. Good one Steve. Jared On Tuesday 18 June 2002 14:23, Orr, Steve wrote: > Here's a performance tuning query to help identify the problem: > > SELECT column_name "The problem is the..." > FROMdba_tab_columns > WHERE owner='SYS' > AND table_name = 'DUAL' > / > > :-) > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
> Economize synapses... paste and execute in SQL*Plus.
Sorry Steve, I can't do that.
Two great figures from the 19th/20th centuries were Nicola Tesla
and Thomas Edison, with Tesla having a clear edge in the intelligence
department, while Edison was from the PT Barnum School of Business.
Given an irregularly shaped object and asked to determine its volume,
Edison would promptly drill a hole in it, get a container with
lines measuring of the volume of liquid it contained, fill the
container and thereby determine the objects volume.
While Edison would be farting around, Tesla would measure the object,
write down the measurements, then proceed to calculate the volume
of the object.
Tesla's methods scaled. Edison's didn't
We have Tesla to thank for our electric power, not Edison, due to
his thinking ability. He also invented radio. When Marconi built on
Tesla's work and tried to patent it, he found Tesla had already
visited the patent office.
As Tesla is my idol, conserving synapses is something I find
inherantly distasteful.
Jared
"Orr, Steve" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/25/2002 08:03 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: SEQ#, DUAL and Oracle literacy
> I had to ponder this for a few seconds.
Economize synapses... paste and execute in SQL*Plus.
-Original Message-
Sent: Saturday, June 22, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L
LOL! I had to ponder this for a few seconds.
Good one Steve.
Jared
On Tuesday 18 June 2002 14:23, Orr, Steve wrote:
> Here's a performance tuning query to help identify the problem:
>
> SELECT column_name "The problem is the..."
> FROMdba_tab_columns
> WHERE owner='SYS'
> AND table_name = 'DUAL'
> /
>
> :-)
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
> I had to ponder this for a few seconds. Economize synapses... paste and execute in SQL*Plus. -Original Message- Sent: Saturday, June 22, 2002 12:53 PM To: Multiple recipients of list ORACLE-L LOL! I had to ponder this for a few seconds. Good one Steve. Jared On Tuesday 18 June 2002 14:23, Orr, Steve wrote: > Here's a performance tuning query to help identify the problem: > > SELECT column_name "The problem is the..." > FROMdba_tab_columns > WHERE owner='SYS' > AND table_name = 'DUAL' > / > > :-) > > -Original Message- > Sent: Tuesday, June 18, 2002 3:07 PM > To: Multiple recipients of list ORACLE-L > > Want to have a good laugh?... read on... I don't think its OT :) > > A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle > Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the > application will get a *specific* Sequence Number for something. > > DBA: Why do you think DUAL is the problem? > Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. > > Boy! Are we in trouble or what?? ;) > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Main Entry: 1du·al Pronunciation: 'dü(-&)l also 'dyü-&lFunction: adjectiveEtymology: Latin dualis, from duo two -- more at TWODate: 16071 of grammatical number : denoting reference to two2 a : consisting of two parts or elements or having two like parts : DOUBLE b : having a double character or nature- du·al·ly /-&(l)-lE/ adverb Main Entry: 2dualFunction: nounDate: 16501 : the dual number of a language2 : a linguistic form in the dual Entry Word: dualFunction: adjectiveText: 1 Synonyms TWOFOLD 1, bifold, binary, double, double-barreled, dualistic, duple, duplex2 Synonyms TWIN, double, paired :))) -- Alexandre - Original Message - From: "Eric D. Pierce" <[EMAIL PROTECTED]> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 3:13 AM Subject: Re: SEQ#, DUAL and Oracle literacy > what is dual?> > On 23 Jun 2002 at 14:45, Jared Still wrote:> > > > > Ahem...> > > > Are you an idiot? > > > > ;)> > > > On Sunday 23 June 2002 11:38, Eric D. Pierce wrote:> > > HELP> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com> -- > Author: Eric D. Pierce> INET: [EMAIL PROTECTED]> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).> audio.gif Description: GIF image
RE: SEQ#, DUAL and Oracle literacy
HELP -Original Message- Sent: Sunday, June 23, 2002 7:48 PM To: Multiple recipients of list ORACLE-L Ahem... Are you an idiot? ;) On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: > HELP > > On 23 Jun 2002 at 1:13, Sakthi , Raj wrote: > > Well, > > does this question get the same place in the 'hall of > > oracle list' as the legendary 'are you an > > idiot..?'...;) > > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
what is dual? On 23 Jun 2002 at 14:45, Jared Still wrote: > > Ahem... > > Are you an idiot? > > ;) > > On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: > > HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Ahem... Are you an idiot? ;) On Sunday 23 June 2002 11:38, Eric D. Pierce wrote: > HELP > > On 23 Jun 2002 at 1:13, Sakthi , Raj wrote: > > Well, > > does this question get the same place in the 'hall of > > oracle list' as the legendary 'are you an > > idiot..?'...;) > > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
HELP On 23 Jun 2002 at 1:13, Sakthi , Raj wrote: > Well, > does this question get the same place in the 'hall of > oracle list' as the legendary 'are you an > idiot..?'...;) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Well, does this question get the same place in the 'hall of oracle list' as the legendary 'are you an idiot..?'...;) --- Jared Still <[EMAIL PROTECTED]> wrote: > On Wednesday 19 June 2002 00:48, Farnsworth, Dave > wrote: > > Hallo, > > > > What is dual? > > Are you a dummy? ;) > > > > > > > > > > -Original Message- > > Sent: Tuesday, June 18, 2002 2:07 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Want to have a good laugh?... read on... I don't > think its OT :) > > > > A few minutes ago, my co-worker DBA was 'ordered' > by one of the Oracle > > Duhvelopers from our 'preferred vendor' to fix the > DUAL table so that the > > application will get a *specific* Sequence Number > for something. > > > > DBA: Why do you think DUAL is the problem? > > Duhveloper: ...'cause I see the PL/SQL code that > says 'from dual'. > > > > Boy! Are we in trouble or what?? ;) > > > > - Kirti > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
if not Janus, how about Narcissus? On Friday 21 June 2002 08:53, Sakthi , Raj wrote: > Next thing you know some of the management types may > take offence to that column name...!!( However clearly > it depicts them..!!) > Lets rename the table as Janus after the 2 faced greek > GOD. > ( Jared since we ARE discussing DUAL this is not OT is > it.?.;) ) > > RS > > --- Alexandre Gorbatchev > > <[EMAIL PROTECTED]> wrote: > > And one column :))) > > > > SQL> describe dual > > Name Null? > > Type > > - > > > > > > DUMMY > > VARCHAR2(1) > > > > -- > > Alexandre > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Friday, June 21, 2002 10:28 AM > > > > > RS wrote: What kinda name is dual...sounds > > > > suspicious..;) > > > > > Especially when you consider that DUAL has ONE > > > > record only :-)) > > > > > Yechiel Adar > > > Mehish > > > - Original Message - > > > To: Multiple recipients of list ORACLE-L > > > > <[EMAIL PROTECTED]> > > > > > Sent: Friday, June 21, 2002 5:58 AM > > > > > > > While you are at it can you fix that name > > > > too...? What > > > > > > kinda name is dual...sounds suspicious..;) > > > > RS > > > > --- "Khedr, Waleed" <[EMAIL PROTECTED]> > > > > wrote: > > > > > So did you fix it? > > > > > > > > > > -Original Message- > > > > > Sent: Tuesday, June 18, 2002 3:07 PM > > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > Want to have a good laugh?... read on... I > > > > don't > > > > > > > think its OT :) > > > > > > > > > > A few minutes ago, my co-worker DBA was > > > > 'ordered' by > > > > > > > one of the Oracle > > > > > Duhvelopers from our 'preferred vendor' to fix > > > > the > > > > > > > DUAL table so that the > > > > > application will get a *specific* Sequence > > > > Number > > > > > > > for something. > > > > > > > > > > DBA: Why do you think DUAL is the problem? > > > > > Duhveloper: ...'cause I see the PL/SQL code > > > > that > > > > > > > says 'from dual'. > > > > > > > > > > Boy! Are we in trouble or what?? ;) > > > > > > > > > > - Kirti > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: > > > > > http://www.orafaq.com > > > > > -- > > > > > Author: Deshpande, Kirti > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services-- (858) 538-5051 > > > > FAX: > > > > > (858) 538-5051 > > > > > San Diego, California-- Public > > > > Internet > > > > > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, > > > > send an > > > > > > > E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling > > > > of > > > > > > > 'ListGuru') and in > > > > > the message BODY, include a line containing: > > > > UNSUB > > > > > > > ORACLE-L > > > > > (or the name of mailing list you want to be > > > > removed > > > > > > > from). You may > > > > > also send the HELP command for other > > > > information > > > > > > > (like subscribing). > > > > > -- > > > > > Please see the official ORACLE-L FAQ: > > > > > http://www.orafaq.com > > > > > -- > > > > > Author: Khedr, Waleed > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services-- (858) 538-5051 > > > > FAX: > > > > > (858) 538-5051 > > > > > San Diego, California-- Public > > > > Internet > > > > > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, > > > > send an > > > > > > > E-Mail message > > > > > to: [EMAIL PROTECTED] (note EXACT spelling > > > > of > > > > > > > 'ListGuru') and in > > > > > the message BODY, include a line containing: > > > > UNSUB > > > > > > > ORACLE-L > > > > > (or the name of mailing list you want to be > > > > removed > > > > > > > from). You may > > > > > also send the HELP command for other > > > > information > > > > > > > (like subscribing). > > > > __ > > > > > > Do You Yahoo!? > > > > Yahoo! - Official partner of 2002 FIFA World Cup > > > > http://fifaworldcup.yahoo.com > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > > http://www.orafaq.com > > > > > > -- > > > > Author: Sakthi , Raj > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > > > > FAX: (858) 538-5051 > > > > > > San Diego, California-- Public Internet > > > > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > > > > an E-Mail message > > > > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > > 'ListGuru') and in > > > > > > the message BODY, include a line containing: > > > > UNSUB ORACLE-L > > >
Re: SEQ#, DUAL and Oracle literacy
On Wednesday 19 June 2002 00:48, Farnsworth, Dave wrote: > Hallo, > > What is dual? Are you a dummy? ;) > > > > -Original Message- > Sent: Tuesday, June 18, 2002 2:07 PM > To: Multiple recipients of list ORACLE-L > > > Want to have a good laugh?... read on... I don't think its OT :) > > A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle > Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the > application will get a *specific* Sequence Number for something. > > DBA: Why do you think DUAL is the problem? > Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. > > Boy! Are we in trouble or what?? ;) > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
LOL! I had to ponder this for a few seconds. Good one Steve. Jared On Tuesday 18 June 2002 14:23, Orr, Steve wrote: > Here's a performance tuning query to help identify the problem: > > > SELECT column_name "The problem is the..." > FROMdba_tab_columns > WHERE owner='SYS' > AND table_name = 'DUAL' > / > > :-) > > -Original Message- > Sent: Tuesday, June 18, 2002 2:13 PM > To: Multiple recipients of list ORACLE-L > > > So did you fix it? > > -Original Message- > Sent: Tuesday, June 18, 2002 3:07 PM > To: Multiple recipients of list ORACLE-L > > > Want to have a good laugh?... read on... I don't think its OT :) > > A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle > Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the > application will get a *specific* Sequence Number for something. > > DBA: Why do you think DUAL is the problem? > Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. > > Boy! Are we in trouble or what?? ;) > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Next thing you know some of the management types may take offence to that column name...!!( However clearly it depicts them..!!) Lets rename the table as Janus after the 2 faced greek GOD. ( Jared since we ARE discussing DUAL this is not OT is it.?.;) ) RS --- Alexandre Gorbatchev <[EMAIL PROTECTED]> wrote: > And one column :))) > > SQL> describe dual > Name Null? > Type > - > > > DUMMY > VARCHAR2(1) > > -- > Alexandre > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Friday, June 21, 2002 10:28 AM > > > > RS wrote: What kinda name is dual...sounds > suspicious..;) > > > > Especially when you consider that DUAL has ONE > record only :-)) > > > > Yechiel Adar > > Mehish > > - Original Message - > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > Sent: Friday, June 21, 2002 5:58 AM > > > > > > > While you are at it can you fix that name > too...? What > > > kinda name is dual...sounds suspicious..;) > > > RS > > > --- "Khedr, Waleed" <[EMAIL PROTECTED]> > wrote: > > > > So did you fix it? > > > > > > > > -Original Message- > > > > Sent: Tuesday, June 18, 2002 3:07 PM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Want to have a good laugh?... read on... I > don't > > > > think its OT :) > > > > > > > > A few minutes ago, my co-worker DBA was > 'ordered' by > > > > one of the Oracle > > > > Duhvelopers from our 'preferred vendor' to fix > the > > > > DUAL table so that the > > > > application will get a *specific* Sequence > Number > > > > for something. > > > > > > > > DBA: Why do you think DUAL is the problem? > > > > Duhveloper: ...'cause I see the PL/SQL code > that > > > > says 'from dual'. > > > > > > > > Boy! Are we in trouble or what?? ;) > > > > > > > > - Kirti > > > > > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > > http://www.orafaq.com > > > > -- > > > > Author: Deshpande, Kirti > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > > > (858) 538-5051 > > > > San Diego, California-- Public > Internet > > > > access / Mailing Lists > > > > > > > > > > > > To REMOVE yourself from this mailing list, > send an > > > > E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling > of > > > > 'ListGuru') and in > > > > the message BODY, include a line containing: > UNSUB > > > > ORACLE-L > > > > (or the name of mailing list you want to be > removed > > > > from). You may > > > > also send the HELP command for other > information > > > > (like subscribing). > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > > http://www.orafaq.com > > > > -- > > > > Author: Khedr, Waleed > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > > > (858) 538-5051 > > > > San Diego, California-- Public > Internet > > > > access / Mailing Lists > > > > > > > > > > > > To REMOVE yourself from this mailing list, > send an > > > > E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling > of > > > > 'ListGuru') and in > > > > the message BODY, include a line containing: > UNSUB > > > > ORACLE-L > > > > (or the name of mailing list you want to be > removed > > > > from). You may > > > > also send the HELP command for other > information > > > > (like subscribing). > > > > > > > > > > __ > > > Do You Yahoo!? > > > Yahoo! - Official partner of 2002 FIFA World Cup > > > http://fifaworldcup.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > > -- > > > Author: Sakthi , Raj > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > > > To REMOVE yourself from this mailing list, send > an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB ORACLE-L > > > (or the name of mailing list you want to be > removed from). You may > > > also send the HELP command for other information > (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Yechiel Adar > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > >
Re: SEQ#, DUAL and Oracle literacy
And one column :))) SQL> describe dual Name Null?Type - DUMMY VARCHAR2(1) -- Alexandre - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 10:28 AM > RS wrote: What kinda name is dual...sounds suspicious..;) > > Especially when you consider that DUAL has ONE record only :-)) > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Friday, June 21, 2002 5:58 AM > > > > While you are at it can you fix that name too...? What > > kinda name is dual...sounds suspicious..;) > > RS > > --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > > > So did you fix it? > > > > > > -Original Message- > > > Sent: Tuesday, June 18, 2002 3:07 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Want to have a good laugh?... read on... I don't > > > think its OT :) > > > > > > A few minutes ago, my co-worker DBA was 'ordered' by > > > one of the Oracle > > > Duhvelopers from our 'preferred vendor' to fix the > > > DUAL table so that the > > > application will get a *specific* Sequence Number > > > for something. > > > > > > DBA: Why do you think DUAL is the problem? > > > Duhveloper: ...'cause I see the PL/SQL code that > > > says 'from dual'. > > > > > > Boy! Are we in trouble or what?? ;) > > > > > > - Kirti > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Deshpande, Kirti > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: > > > (858) 538-5051 > > > San Diego, California-- Public Internet > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > > ORACLE-L > > > (or the name of mailing list you want to be removed > > > from). You may > > > also send the HELP command for other information > > > (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Khedr, Waleed > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: > > > (858) 538-5051 > > > San Diego, California-- Public Internet > > > access / Mailing Lists > > > > > > > > To REMOVE yourself from this mailing list, send an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > > ORACLE-L > > > (or the name of mailing list you want to be removed > > > from). You may > > > also send the HELP command for other information > > > (like subscribing). > > > > > > __ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Sakthi , Raj > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: SEQ#, DUAL and Oracle literacy
RS wrote: What kinda name is dual...sounds suspicious..;) Especially when you consider that DUAL has ONE record only :-)) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, June 21, 2002 5:58 AM > While you are at it can you fix that name too...? What > kinda name is dual...sounds suspicious..;) > RS > --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > > So did you fix it? > > > > -Original Message- > > Sent: Tuesday, June 18, 2002 3:07 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Want to have a good laugh?... read on... I don't > > think its OT :) > > > > A few minutes ago, my co-worker DBA was 'ordered' by > > one of the Oracle > > Duhvelopers from our 'preferred vendor' to fix the > > DUAL table so that the > > application will get a *specific* Sequence Number > > for something. > > > > DBA: Why do you think DUAL is the problem? > > Duhveloper: ...'cause I see the PL/SQL code that > > says 'from dual'. > > > > Boy! Are we in trouble or what?? ;) > > > > - Kirti > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Deshpande, Kirti > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Khedr, Waleed > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Yahoo! - Official partner of 2002 FIFA World Cup > http://fifaworldcup.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sakthi , Raj > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
While you are at it can you fix that name too...? What kinda name is dual...sounds suspicious..;) RS --- "Khedr, Waleed" <[EMAIL PROTECTED]> wrote: > So did you fix it? > > -Original Message- > Sent: Tuesday, June 18, 2002 3:07 PM > To: Multiple recipients of list ORACLE-L > > > Want to have a good laugh?... read on... I don't > think its OT :) > > A few minutes ago, my co-worker DBA was 'ordered' by > one of the Oracle > Duhvelopers from our 'preferred vendor' to fix the > DUAL table so that the > application will get a *specific* Sequence Number > for something. > > DBA: Why do you think DUAL is the problem? > Duhveloper: ...'cause I see the PL/SQL code that > says 'from dual'. > > Boy! Are we in trouble or what?? ;) > > - Kirti > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SEQ#, DUAL and Oracle literacy
Don't see any problems :-) CREATE TABLE SYS.SUPER_DUAL (specific_seq_num NUMBER(10)); DROP PUBLIC SYNONYM DUAL; CREATE PUBLIC SYNONYM DUAL FOR SYS.SUPER_DUAL; INSERT INTO SYS.SUPER_DUAL VALUES(666); Vua-la!!! ;) -- Alexandre > Want to have a good laugh?... read on... I don't think its OT :) > > A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle > Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the > application will get a *specific* Sequence Number for something. > > DBA: Why do you think DUAL is the problem? > Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. > > Boy! Are we in trouble or what?? ;) > > - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
Hallo, What is dual? -Original Message- Sent: Tuesday, June 18, 2002 2:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
The problem seems to be with the preferred ven-duh ! Regards: Ferenc Mantfeld Senior Performance Engineer Siebel Performance Engineering Melbourne, 3000, VIC, Australia Only Robinson Crusoe had all his work done by Friday -Original Message- Sent: Tuesday, 18 June 2002 12:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ferenc Mantfeld INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
Sure !! :) I think the DBA suggested that the Duhveloper reads Chapter 1 from Tom Kyte's book, if not anything else. I volunteered to read it to them using my own copy ;) I would love to do that!! My boss has read a few chapters from this book (upon my request) and is using his new found Oracle knowledge very well. Helps us a lot that way !! Now he understands what we are dealing with. - Kirti -Original Message- Sent: Tuesday, June 18, 2002 2:13 PM To: Multiple recipients of list ORACLE-L So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
Here's a performance tuning query to help identify the problem: SELECT column_name "The problem is the..." FROMdba_tab_columns WHERE owner='SYS' AND table_name = 'DUAL' / :-) -Original Message- Sent: Tuesday, June 18, 2002 2:13 PM To: Multiple recipients of list ORACLE-L So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
My deepest condolences... -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
So did you fix it? -Original Message- Sent: Tuesday, June 18, 2002 3:07 PM To: Multiple recipients of list ORACLE-L Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SEQ#, DUAL and Oracle literacy
I'm at the complete bottom of Oracle knowledge and even I know what the dual table is. Want to have a good laugh?... read on... I don't think its OT :) A few minutes ago, my co-worker DBA was 'ordered' by one of the Oracle Duhvelopers from our 'preferred vendor' to fix the DUAL table so that the application will get a *specific* Sequence Number for something. DBA: Why do you think DUAL is the problem? Duhveloper: ...'cause I see the PL/SQL code that says 'from dual'. Boy! Are we in trouble or what?? ;) - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hayes, Scott INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
