Re: Long & cblog | Autonumbering with Oracle

"@did" wrote:

> Well, I have 2 questions that could bring me a whole lot further.
>
> 1) I'm looking for some solutions to put large RNA sequentions into an
> oracle database. Could somebody please tell me what I should use best
> and why: Long or Cblog. Does somebody know a real difference ?
>
> UAAGGCAGUG GUAGCGCUGA AGAAUAUUCG UGCAAUUGUC GUUAUUCAUU AUAAAAAGGG
>
> 2) I was searching for some kind of autonumbering for a key, but
> didn't find something just yet. Could somebody tell me if this is
> possible with Oracle.
>
> Thx in advance !
>
> C.

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.

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

Daniel Morgan Received on Fri Dec 06 2002 - 16:09:07 CST