LuckyLucks
asked on
clob to char in oracle
hi
To string output a clob value thats about 4032 chars, how can I accomplish this?
I have tried, with no luck the following:
DBMS_LOB.SUBSTR (myfield, 4050)
DBMS_LOB.SUBSTR (myfield)
to_char(myfield)
To string output a clob value thats about 4032 chars, how can I accomplish this?
I have tried, with no luck the following:
DBMS_LOB.SUBSTR (myfield, 4050)
DBMS_LOB.SUBSTR (myfield)
to_char(myfield)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you are using functions that return a varchar2 you are bound by the limits for varchar2.
If you just select the column without any functions, it should be just fine:
select myfield from yourtable;