Skip to Main Content

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 use CLOB datatype for storing limitless characters in column each rows?

User_9URBTSep 19 2022

Hello! Everyone,
I want to use CLOB datatype instead of varchar2(4000), in which I want store limitless characters . However, its easy to declare the string based column to CLOB but the main problem is when i insert the paragraph it stores and on runtime when check it shows just a single line.. As am new, your guidance will help me a-lot thanks.

This post has been answered by User_9URBT on Sep 21 2022
Jump to Answer
Comments
Post Details
Added on Sep 19 2022
5 comments
265 views