Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: clob to varchar2

Re: clob to varchar2

From: Angel Vera <gunfus_at_yahoo.com>
Date: Mon, 14 May 2001 18:56:23 -0400
Message-ID: <9dpnr8$i5i$1@tornews.torolab.ibm.com> 






Effiency, is rather clear to me.



"Xiaobin Guan" <xiaguan_at_nhgri.nih.gov> wrote in message
news:6TUL6.26$l5.51559_at_mencken.net.nih.gov...


> Hi there,

>

> I have a column, which stores 3000 characters, and it is using CLOB type

> now.  How can I change it to varchar2(3000)? What's the advantage and

> disadvantage of using clob vs. varchar2 in this case?

>

> Thanks a lot!

> Xiaobin

>

>

Received on Mon May 14 2001 - 17:56:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US