Re: how to use a sequence?

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Fri, 23 Apr 2004 11:43:44 GMT
Message-ID: <Qj7ic.27778$V_3.7790@news-server.bigpond.net.au>

"Eric Lee" <lichoil_at_tom.com> wrote in message news:c6at0k$cak$1_at_mail.cn99.com...
> I have created a sequence named idx.
> How can I use this sequence when I create a table?
> I wanna create a table with primary key which can auto increment.
>
>
> thanks advance.
>
>

Eric,

Daniel Morgan has a reference for this type of question at http://www.psoug.org/reference/sequences.html

Douglas Hawthorne Received on Fri Apr 23 2004 - 06:43:44 CDT

This message: [ Message body ]
Next message: Niall Litchfield: "Re: giving another user "grant XXX" privs on my schema objects"
Previous message: Niall Litchfield: "Re: how to use a sequence?"
In reply to: Eric Lee: "how to use a sequence?"
Next in thread: sybrandb_at_yahoo.com: "Re: how to use a sequence?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US