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
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
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 ) ;
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
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
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
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
...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
, 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
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
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
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
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
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
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
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
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
And one column :)))
SQL describe dual
Name Null?Type
-
DUMMY VARCHAR2(1)
--
Alexandre
- Original Message -
To: Multiple
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
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
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:
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
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
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
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
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
26 matches
Mail list logo