Re: LONG VARCHAR

Yong <yhuang_at_slb.com> wrote in message
news:8l2ln4$iu7$1_at_news.sinet.slb.com...
> All you said is very correct except LONG VARCHAR:
>
> SQL> create table q (a long varchar);
>
> Table created.
>
> SQL> select column_name, data_type from user_tab_columns where table_name
 =
> 'Q';
>
> COLUMN_NAME DATA_TYPE
> ------------------------------ -------------------------------------------
 --
> ----
> A LONG
>
> However, according to Concept manual, there's no such datatype long
 varchar.
> Long varchar is the datatype from DB2 or SQL/DS that can be converted to
> long in Oracle (see
> technet.oracle.com/doc/oracle8i_816/server.816/a76965/c10datyp.htm#629).
> Apparently Oracle automatically does this conversion for you as I showed
> above.
>
> Yong Huang

Yup. And if you declare a column to be a mere 'varchar', Oracle will correctly create that as a 'varchar2' for you. Wouldn't call that a conversion myself, since there's no actual data involved at the point of creating a table, but whatever: it works!

Regards
HJR
>
> Howard J. Rogers <howardjr_at_www.com> wrote in message
> news:397080a6$1_at_news.iprimus.com.au...
> >
> > "Julien Godfroid" <j.gofdfroid_at_co-link.be> wrote in message
> > news:396C8FF1.73EBC450_at_co-link.be...
> > > Hi
> > >
> > > I'm exporting a database from Sybase to Oracle8 and I've got a problem
> > > with LONG VARCHAR fields. They're not limited in number(in a same
 table)
> > > in sybase but seems to be in Oracle. Am I Right ? Is there a magic
> > > solution ?
> > >
> >
> > No such thing as a long varchar, but if you are talking about LONGs and
 LONG
> > RAWs then, yes, there's a limit of one such field per table.
> >
> > If you have the chance to work with Oracle 8 and above, then you can use
> > CLOBS and BLOBS which are (respectively) the replacements for LONGs and
 LONG
> > RAWs -and you can have any number of those in an Oracle 8 table.
> >
> > Not magic, but I hope it'll do,
> >
> > Regards
> > HJR
> >
> >
> >
> >
> > > Thanks
> > >
> > > Ju
> > >
> >
> >
>
>
Received on Wed Jul 19 2000 - 00:00:00 CDT