Home » SQL & PL/SQL » SQL & PL/SQL » using clob instead of varchar2
using clob instead of varchar2 [message #448510] Tue, 23 March 2010 18:31 Go to next message
Messages: 202
Registered: April 2006
Senior Member
in our application we are using clob column instead of varchar2 becasue varchar2 does not allow more that 4000 chars, so Using clob allows to put data of any length, will it cause performance issues ? we have this column in almost in all tables, is it recommended ?when is it recomended to use clob ?
Re: using clob instead of varchar2 [message #448515 is a reply to message #448510] Tue, 23 March 2010 22:23 Go to previous messageGo to next message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
if the column needs less than 4000 characters, it would not be wise to use anything other than a

the clob would just lend additional overhead, being a slightly more "complex" type.

For more reference search On documents And ASKTOM
sriram Smile
Re: using clob instead of varchar2 [message #448537 is a reply to message #448510] Wed, 24 March 2010 00:43 Go to previous message
Michel Cadot
Messages: 65090
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ Yes but if you need it...
2/ No only when you need it
3/ When you cannot use VARCHAR2

Previous Topic: sysdate performance
Next Topic: multiple rows to single
Goto Forum:

Current Time: Fri Jul 28 06:36:21 CDT 2017

Total time taken to generate the page: 0.15258 seconds