SQL & PL/SQL

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!

How to Convert varchar2 to clob datatype.

fameFeb 7 2012 — edited Feb 7 2012

Hi,
If select below query it datatype should be varchar2 but i want convert the text into clob.

select 'World' from dual;

Regards,
Fame

This post has been answered by 448013 on Feb 7 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2012

Added on Feb 7 2012

3 comments

83,000 views