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 store 30000 plus characters in a particular text field, which datatype should be use for it?

User_9URBTSep 21 2022 — edited Sep 21 2022

Here, I have a problem in which I want to store 30000 plus characters (paragraphs) in an individual field instance. Moreover, I tried the CLOB datatype for a column, but when I am crossing the characters storing up to 2900, it gives me an error: ORA-00972: the identifier is too long. So which datatype is best/suitable to store maximum characters or I would say that store 3, 2 paragraphs in a particular field single row. As a newbie, your meaningful response will be appreciable.

Thanks

This post has been answered by User_9URBT on Sep 21 2022

Jump to Answer

Added on Sep 21 2022

#oracle, #sqlplus

5 comments

1,019 views