Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: field types possible with Oracle

Re: field types possible with Oracle

From: Barbara Kennedy <barbken_at_teleport.com>
Date: Tue, 17 Nov 1998 23:05:25 GMT
Message-ID: <Vin42.2335$Sz4.1315918@news.teleport.com>


Numbers (precision up to 38 places and you can specify the scale and precision)
Dates/time - precision to 1 second
Raw (binary - small under 256 bytes, 2 gigs - long raw - , 4 gigs blobs - binary large objects and bfiles - external files) Character (up to 4000 bytes, 2 gigs - long, 4 gigs clobs bfiles, nclobs - character sets
User defined Object's
Array - varray
nested tables
refs (think of them as pointers)

So with those you could have the below. Jim
Robert Prell wrote in message <3652fcd4.3016635_at_news.pacbell.net>...
>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!
Received on Tue Nov 17 1998 - 17:05:25 CST

Original text of this message

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