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
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 a private synonym?
Explain index?
What are the different types of synonyms?
What is parameterized cursor in oracle?
What is connection pooling in oracle?
What is index in Oracle?
What is a database table in oracle?
What operating systems are supported by oracle database 10g xe?
How will you identify oracle database software release?
What is partitioned table in Oracle?
What is oracle used for?
Explain joins in oracle?
What is tns service name?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is meant by a deadlock situation?