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
- 10345 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 to define a variable of a specific record type?
How to synchronize 2 schema's objects?
What is the difference between formal parameters and actual parameters?
How to check your oracle database 10g xe installation?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to apply filtering criteria at group level in oracle?
How do I manually create a database in oracle?
which language is used to develop the oracle........?
How to insert a record into a table?
What is the difference between a vector and an Array? (Java)
can u call user defined functions in select statements
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Oracle General 
