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
- 10099 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 do I escape a reserved word in oracle?
What are the ansi data types supported in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the minimum client footprint required to connect c# to an oracle database?
What is an oracle cursor variable?
What are the components of logical database structure in oracle database?
How can I introduce multiple conditions in like operator?
How to use subqueries with the in operator using oracle?
master table and child table performances and comparisons in Oracle ?
How to define a cusotmer as a supplier in ORACLE R12
Explain a private synonyms?
What are a cluster and non-cluster index?
What are the differences between char and nchar in oracle?
How to define an anonymous procedure without variables?
how do u setup a replication site?
