Re: Long & cblog | Autonumbering with Oracle

From: <_at_did>
Date: Fri, 06 Dec 2002 23:58:38 GMT
Message-ID: <kce2vuooeevlop81opival4u5aepmrjir8@4ax.com>

>Use CLOB because Oracle either will in the next release, or shortly
>thereafter drop LONG as a data type.
>
>Also there are tools in the DBMS_LOB package that make working with CLOBs
>substantially easier than working with LONGs.

Ok, thx, I was doubting but then I'll use CLOB.

>Autonumbering in Oracle is done with sequences. And then incorporating a
>call to sequence_name.NEXTVAL in the insert statement or an insert
>trigger.

Could you be a bit more specific please. How can I make such a sequence ?
This could al be very basic to you but it would help me a lot.

Thx !

Cliff Received on Fri Dec 06 2002 - 17:58:38 CST