.
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?
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
> com>
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>
>
#x27;[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>,
> com>
> "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
>
> cc:
r heard off.
Cherie
"Gogala,
Mladen" To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subjec
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> "'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc:
07/30/02 12:46 Subject: RE: Creating sequences
on the DUAL table?
PM
>cc:
Sent by: Subject: RE: Creating sequences on the
DUAL table?
[EMAIL PROTECTED]
"'[EMAIL PROTECTED]'"
<[EMAIL PROTECTED]>
cc:
07/30/02 12:46 Subject: RE: Creating
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 P
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:
>
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 structural
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 w
.com> cc:
Sent by: Subject: RE: Creating sequences on the
DUAL table?
[EMAIL PROTECTED]
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
http://www.optimal
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
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 generall
16 matches
Mail list logo