Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10269 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
what is the difference between primary key & foreign key?
57 Answers CTS, Infosys, La Multi, Sparsh, Wipro,
Name the various constraints used in oracle?
Explain oracle instance.
Difference between pre-select and pre-query
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Youre getting high busy buffer waits - how can you find whats causing it?
What are the different pseudo commands? Explain in general?
what are archived logs?
how to do daily transactions with out sql* loader control file regesterd in apps?
Difference between NO DATA FOUND and %NOTFOUND?
Are truncate and delete commands same? If so why?
What is concurrency in oracle?
Oracle General 
