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 ) ;
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 li
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
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...
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.
-Origi
...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 thou
pond 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
> 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 200
listic, 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
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 sam
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 Ci
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
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 PROTECTE
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? ;)
>
>
> >
> >
>
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 si
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 :)
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 tab
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 PROTEC
And one column :)))
SQL> describe dual
Name Null?Type
-
DUMMY VARCHAR2(1)
--
Alexandre
- Original Message -
To: "Multipl
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
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
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
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 'prefe
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: Multi
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
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-
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 'pre
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
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 th
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 th
30 matches
Mail list logo
