seq
Hello list , why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle nocache ; and 2. test is Name Null?Type ID NUMBER(7) ID2NUMBER -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
because the second insert is returning the result of the first insert. try running each one twice in a row and see what happens. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 3:49 PM To: Multiple recipients of list ORACLE-L Hello list , why does : insert into test values (mysequence.nextval, mysequence.currval ) ; have the same effect as insert into test values (mysequence.currval, mysequence.nextval ) ; where 1. mysequence is create sequence mysequence increment by 1 start with 1 maxvalue 1000 nocycle nocache ; and 2. test is Name Null?Type ID NUMBER(7) ID2NUMBER -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Try running the 2nd statement first, just after
logon to the database, and see what happens.
Then read the fine manual for sequences. ;)
Jared
On Tue, 2003-12-23 at 12:49, [EMAIL PROTECTED] wrote:
Hello list , why does :
insert into test values (mysequence.nextval, mysequence.currval ) ;
have the same effect as
insert into test values (mysequence.currval, mysequence.nextval ) ;
where
1. mysequence is
create sequence mysequence increment by 1 start with 1 maxvalue 1000
nocycle nocache ;
and
2. test is
Name Null?Type
ID NUMBER(7)
ID2NUMBER
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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
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
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 '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
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
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
...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
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
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? ;) g -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
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
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
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
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
On Wednesday 19 June 2002 00:48, Farnsworth, Dave wrote: Hallo, What is dual? Are you a dummy? ;) g -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
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 (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
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
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 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
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 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
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
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
Hallo, What is dual? g -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
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
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).
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
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).
