Re: oracle

sireesha wrote:

>Are there any rules pertaining to the creation of table in oracle
>
>such as : maximum length of all columns(sum of all columns) should be
>
>less than ##### number.
>
>if so please give the details
>
>
>
>ex : create table xx(num1 number(x1),nm varchar2(x2)...)
>
>what is the maximum length of x1+x2+.....
>
>thanks
>
>
>--
>Posted via http://dbforums.com
>
>
The primary rule is sanity. If you have a table with more than a few dozen columns likely
you need to take a course on relational database theory.

No one can possibly answer your question as asked as the answer is version specific. If
you are looking for documented rules look at http://tahiti.oracle.com

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)