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
- 10264 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 is meant by joins? List out the types of joins.
How to drop an existing table in oracle?
How to rename a tablespace in oracle?
How to declare a local variable?
Difference between the “verify” and “feedback” command?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
what happened to the global index when I truncate the data in one of the partition?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain oracle left join with an example?
Difference between varchar and varchar2 data types?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
List the types of joins used in writing subqueries?
How to Truncate Table in Oracle
How to use "in out" parameter properly?
