i can't insert column value greater than 4000 characters at
one instance even i am using CLOB datatype . how to insert
efficiently more than 4000 characters ? And please let me
know how to impose inline and out-of line constraints on
oracle column???
Thanks in Advance...
Prakash
- 2 Answers
- 9356 Views
- I also Faced
- E-Mail Answers
Answer Posted / prakashdasari
we can solve this problem in two ways as of my knowledge.
1)Write that total information (>4000) in a file and upload this file to CLOB data type.
2)Another way is we need to split the string to <=4000 characters substrings and each one need to be append by using to_clob() function available in oracle.
for ex. to_clob('4000characters sub string') | to_clob('4000characters sub string') | to_clob('4000characters sub string') |....... so on.
i used second one for my requirement because i dont want to disturb my well developed product code.Just i added as a extra function.
Than Q...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is oracle data type?
How to set up autotrace for a user account?
How do we get field details of a table?
How to get a list of all user accounts in the database?
Explain constraining triggers.
How many categories of data types?
What is execute immediate in oracle?
Explain the use of inctype option in exp command.
Explain what are synonyms used for?
Explain the importance of .pll extension in oracle?
How to select an oracle system id (sid)?
State the difference between a primary key and foreign key?
How to turn on or off recycle bin for the session?
What happens if the imported table already exists?
How to name query output columns in oracle?
