Re: SEQUENCE

From: Tim Johnston <tjohnston_at_quallaby.com>
Date: Wed, 30 Jun 2004 16:13:56 -0400
Message-ID: <40E31F04.7040709@quallaby.com>

Hi Seema...

A sequence is not "assigned" to a column... A sequence is a stand alone

object... The application may use a sequence to populate one or more 
columns... A trigger may automatically populate a column with a sequence 
value... It all depends on how you use the sequence... Read the Concepts 

guide for more info...

Tim

Seema Singh wrote:

>Hi,
>is there any way we can find sequence name "test" assigned to which table's
>columns?
>thx
>
>_________________________________________________________________
>FREE pop-up blocking with the new MSN Toolbar – get it now!
>http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
>
>----------------------------------------------------------------
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>----------------------------------------------------------------
>To unsubscribe send email to: oracle-l-request_at_freelists.org
>put 'unsubscribe' in the subject line.
>--
>Archives are at http://www.freelists.org/archives/oracle-l/
>FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
>-----------------------------------------------------------------
>
>

-- 
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100



----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jun 30 2004 - 15:10:24 CDT