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
- 9641 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
How to use "if" statements on multiple conditions?
Can sub procedure/function be called recursively?
What do you mean by merge in oracle and how can we merge two tables?
What is an oracle database table?
Explain an exception?
What is index in Oracle?
What is define in oracle?
How to update values in a table in oracle?
What is meant by joins?
What do you mean by a tablespace?
What is ADDM Advisor in Oracle?
Give the various rollback segment states.
How to connect asp pages to oracle servers?
How to use subqueries with the exists operator in oracle?
Explain what are the characteristics of data files?
