I already tried that one..
but the concern is that I added these three columns in table to replace the CLOB columns.
As there was performance issue with CLOB column..
So if I use the to_Clob in select will it not create the same performance issue.???
OR rather how oracle treat TO_CLOB and selecting CLOB colunms in terms of performance?
Any pointers on this?
I would fix my CLOB issue and let the database do the heavy lifting...
How were you defining the CLOB column? If you fail to include the LOB Storage clause, you force the system to do a default storage each time a BLOB or CLOB exceeds 4000 bytes. When you this occurs the result is often datafile fragmentation and performance problems. You can also have LOB performance issues if your buffer cache is incorrectly set.