Re: field types possible with Oracle

From: <mgogala_at_rocketmail.com>
Date: Fri, 20 Nov 1998 06:05:31 GMT
Message-ID: <7330r3$se0$1@nnrp1.dejanews.com>

In article <3652fcd4.3016635_at_news.pacbell.net>, RPrell_at_PacBell.Net (Robert Prell) wrote:
> Does oracle support field types of;
>
> Binary/bit?
>
> Memo/text?
>
> Intiger?
>
> If not what field types do you suggest I use. Also if anyone has a
> list of allowed field types for Oracle 8.05 or better It would be
> greatly appreciated!
>

Oracle basic field types are CHAR,VARCHAR2,DATE,NUMBER,BLOB,CLOB,BFILE, NCLOB, RAW, LONG and LONG RAW. BFILE type allows you to attach a file to the Oracle RDBMS and read it with whatever reading program you use. You cannot however modify it through the Oracle RDBMS. BLOBs are stored internally and can be modified. BLOB= Binary Large Object, CLOB=Character LOB and NCLOB = National Character LOB. Choose whatever type you want. You can store ASCII text into CLOB, MS-WORD memo into BLOB etc. May the force be with you, Mladen Gogala

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Nov 20 1998 - 00:05:31 CST