Hi Dinesh,

You can use LONG or CLOB. we can store up to 2GB data in the two data types.
or else you make a file and store you data in the file.



Regards,
Siva.P
Bangalore

________________________________

From: dgaikwad [mailto:oracledba-ezmlmshield-x98102418.[Email address protected]
Sent: Fri 12/28/2007 3:50 PM
To: LazyDBA Discussion
Subject: Varchar2 Max size



Hi DBAs'

How can I Insert an data of More than 5000 of characters in a table .





Thanks & Regards,
Dinesh G.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html






***********************
No virus was detected in the attachment no filename
No virus was detected in the attachment no filename

Your mail has been scanned by InterScan.
***********-***********


*********************************************************************************************************************************************************************
"This message and any attachments are solely for the intended recipient and may contain Birlasoft confidential or privileged information. If you are not the intended recipient,any disclosure,copying, use, or distribution of the information included in this message and any attachments is
prohibited. If you have received this communication in error, please notify us by reply e-mail at ([Email address protected] and permanently delete this message and any attachments. Thank you."
*********************************************************************************************************************************************************************

Oracle LazyDBA home page