Re: Newbie: Max no. of fields?

skannan_at_cardinal.fs.com ( S. Kannan) wrote:

[snip]
>Oracle will handle from 1 to 254 columns/table (ORACLE7). I don't think
>there is any limit to the number of tables that can exist in a database.
>It depends on the amount of disk space you have.
 

>You can have several hundred or several thousand fields, but NOT ALL
>in one table.

How about View? Is view also limited to max 254 columns/view? I'm still very new in Oracle. TIA.

--
Eddy Setiawan (setiawan_at_singnet.com.sg)
DBA, National Computer Board of Singapore (NCB), http://www.ncb.gov.sg/
Disclaimer: Opinions expressed are strictly private.