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
- 9130 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 an oracle recycle bin?
What is oracle datasource?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to omit columns with default values in insert statement in oracle?
What do you understand by a database object? Can you list a few of them?
How to insert multiple rows with one insert statement in oracle?
what are views?
Explain what are synonyms used for?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
How to fetch the row which has the max value for a column?
How to export your connection information to a file?
How to write an inner join with the where clause in oracle?
Oracle General 
