Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: field types possible with Oracle
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
![]() |
![]() |