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
- 10261 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 |
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
difference between oracle8i and oracle9i
What are the factors causing the reparsing of SQL statements in SGA?
What is a procedure in oracle?
How do we switch from init.ora file to asp file?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is a sub query and what are the different types of subqueries?
What is Hash Index?
How to change system global area (sga) in oracle?
What is an oracle recycle bin?
Youre getting high busy buffer waits - how can you find whats causing it?
How to start your 10g xe server?
Oracle General 
