Home » SQL & PL/SQL » SQL & PL/SQL » Query on Performace Issue (Oracle 10g)
Query on Performace Issue [message #356552] Fri, 31 October 2008 02:25 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Want to know which would be the better approach in 10g
Converting LONG data type to LOB or CLOB?

Is it required to change char datatype to Varchar2 for performance enhancement?


Thanks in advance..

Regards,
Oli
Re: Query on Performace Issue [message #356553 is a reply to message #356552] Fri, 31 October 2008 02:27 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
LONG -> CLOB
CHAR -> VARCHAR2

Regards
Michel
Re: Query on Performace Issue [message #356555 is a reply to message #356553] Fri, 31 October 2008 02:33 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Thank you very much for the update Michel.

Regards,
Oli

[Updated on: Fri, 31 October 2008 03:14]

Report message to a moderator

Previous Topic: Ref Cursors
Next Topic: Passing the Collection Type as argument in procedure for oracle 10g R2
Goto Forum:
  


Current Time: Sat Dec 03 18:15:12 CST 2016

Total time taken to generate the page: 0.07534 seconds