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!

Converting CLOB to Varchar2

user637544Jun 10 2009 — edited Jun 10 2009

I am storing my SQLs in a table column which has datatype CLOB. i want to execute this SQL dynamically using execute immediate command. Can i used to_char function to convert CLOB to VARCHAR2? Can i execute clob directly?

This post has been answered by MichaelS on Jun 10 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 8 2009

Added on Jun 10 2009

4 comments

443 views