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
- 10246 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 Data Block ?
List the types of joins used in writing subqueries?
What is a View ?
what are different types of deletes?
Explain the function of optimizer in oracle?
What is the max number of columns in an oracle table?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
What is flashback Query ? And Use ?
What are the Limitations of a CHECK Constraint ?
What are the various constraints used in oracle?
what is the use of rank function?
Explain the concept of the DUAL table.
Oracle General 
