0

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 enter image description here

Improve this question

1 Answer 1

Reset to default
0

This is just a display limitation. By default SQL*Plus shows a limited amount of characters for LONG and LOB columns. This limit can be increased as:

set long 2000000000
Improve this answer
1
  • Thank you for the guidance, it works fine.
    – Faisal.softech
    Sep 21, 2022 at 5:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.