How to use CLOB datatype for storing limitless characters in column each rows?
0
votes
1
answer
233
views
I want to use CLOB datatype instead of varchar2(4000) and long, 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.
I have tried this, on runtime it only displays limited characters. I want to store one page paragraph in single row and on runtime it displays all the characters of the paragraph.
Note:
Using SQL*PLUS

Asked by Faisal.softech
(1 rep)
Sep 20, 2022, 07:58 AM
Last activity: Jun 5, 2025, 09:07 AM
Last activity: Jun 5, 2025, 09:07 AM