H? Sequences are not created on the dual table. Sequences exist as independent
entities. Ofttimes, sequence values are selected using the dual table (e.g., select
seqname.nextval from dual) -- this is a coding choice. Performance of queries that
select from the dual table are generally
Title: RE: Creating sequences on the DUAL table?
answer below
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
I have a request from one of our developers to create two new
sequences on
the DUAL table.
This seems like a bad idea to me. I've never had
Cherie,
My first response is 'WHY?'. Do they mean that they want to create 2
new sequences and use the DUAL table to retrieve the values? It will cause
performance problems and there are better solutions. I have some information
on the performance implications of DUAL at
cc:
Sent by: Subject: RE: Creating sequences on the
DUAL table?
[EMAIL PROTECTED
Sounds like your developer hangs out with some of our developers! ;)
I am sorry to say but, I guess the syntax ...from dual could be confusing
to the developer.
Your understanding is just fine. Don't do anything with dual..
May be briefly explaining to the developer how sequence number
Title: RE: Creating sequences on the DUAL table?
Sequences are DB objects independent of any tables including dual (not
possible to create a sequence on a table. Sequences are sometimes used
to populate the PK of a table, but the actual sequence and the table are
not structurally related
What are sequence on the table? All I know about sequences
is that they are entities for fas generation of unique numbers
without encountering locks. They are standalone entries without
much connection to any other object.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
Cherie,
You don't create sequences on a table, they are objects in and of
themselves.
So you can create the sequences for the developers but I'm
wondering where they got the notion that sequences were created on a
table. And why they want to use DUAL.
Rachel
--- [EMAIL PROTECTED] wrote:
]'
[EMAIL PROTECTED]
cc:
07/30/02 12:46 Subject: RE: Creating sequences on the
DUAL table?
PM
PROTECTED]
point.comcc:
Sent by: Subject: RE: Creating sequences on the
DUAL table?
[EMAIL PROTECTED
],
com '[EMAIL PROTECTED]'
[EMAIL PROTECTED]
cc:
07/30/02 12:46 Subject: RE: Creating sequences
on the DUAL table?
PM
Cherie
I would think they probably saw something like
select sequence_name.nextval from dual;
Maybe they thought the sequence and dual were connected in some manner.
-Original Message-
Sent: Tuesday, July 30, 2002 2:15 PM
To: Multiple recipients of list ORACLE-L
Cherie,
You don't create
:
com Subject: RE: Creating sequences on the
DUAL table?
Sent by:
[EMAIL PROTECTED
:
07/30/02 12:46 Subject: RE: Creating
sequences on the DUAL table?
PM
]' [EMAIL PROTECTED]
cc:
07/30/02 12:46 Subject: RE: Creating
sequences on the DUAL table?
PM
.
Jared
Fink, Dan [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
07/30/2002 01:31 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: Creating sequences on the DUAL table?
To be more accurate, a sequence
16 matches
Mail list logo