varchar2 can go to 4000 (yes, in 8i) it's in the SQL reference manual, under "datatypes"
--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote: > > Qs What Datatypes Can be Used for 2 Columns of Size 3000 in 1 Table > to Store Character Data ? > > NOTE - 2 Columns of LONG Datatype are NOT Allowed in 1 Table > > create table test10 (test1 long,test2 long); > create table test10 (test1 long,test2 long) > * > ERROR at line 1: > ORA-01754: a table may contain only one column of type LONG > > Qs Also please tell any Limitations , Disadvantages when using any > Substitute > Advised Datatype ? > > Thanks > > P.S. Any Disadvantages with using CLOB ? > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: VIVEK_SHARMA > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing > Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).