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
- 10247 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
What are a query and state the different types of queries and their uses?
What is a tns file?
What is program global area (pga) in oracle?
How to connect ms access to oracle servers?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to create a new tablespace in oracle?
What do you mean by merge in oracle and how can you merge two tables?
How to update values in a table in oracle?
Describe an oracle table?
How to do paging with oracle?
How to check the oracle tns settings?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How to invoke the data pump export utility?
When do you get a .pll extension in oracle?
