Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is it possilble to convert a table column from clob to varchar?

990903Feb 13 2013 — edited Feb 13 2013
Hi all,

Is it possilble to convert a table column from clob to varchar if the column having text data?

Scenario is :

one dev needs a column col1 in a table (tab) as varchar data type.

The datatype of that column col1 is clob and having text data.

PLs suggest..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2013
Added on Feb 13 2013
8 comments
272 views