Home » SQL & PL/SQL » SQL & PL/SQL » Need help!!!
Need help!!! [message #376470] Wed, 17 December 2008 08:02 Go to next message
saic
Messages: 27
Registered: December 2008
Junior Member
Hi One to All

My req is:i have one sql statement , it returning 2000 char,but iam useing dbms_out it showing only 255 char,i need to see the 2000 char, for this what i can do.

thank
Saic
Re: Need help!!! [message #376471 is a reply to message #376470] Wed, 17 December 2008 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Very useful title, why did you only put 3 exclamation marks? Why not 5 or 7 or 13?

Split the string.

Regards
Michel

[Updated on: Wed, 17 December 2008 08:07]

Report message to a moderator

Re: Need help!!! [message #376472 is a reply to message #376471] Wed, 17 December 2008 08:12 Go to previous messageGo to next message
saic
Messages: 27
Registered: December 2008
Junior Member
If u dotMind Can u Explain how to do this

thank for you are help
Re: Need help!!! [message #376473 is a reply to message #376472] Wed, 17 December 2008 08:20 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
saic wrote on Wed, 17 December 2008 14:12
If u dotMind Can u Explain how to do this

thank for you are help

If you do not mind, please read the forum guidelines on how to post. Post what you have tried. Avoid IM speak.
Thanks
Re: Need help!!! [message #376567 is a reply to message #376470] Wed, 17 December 2008 21:02 Go to previous message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:146412348066
Previous Topic: NLS_LANG and ORA-00922
Next Topic: simple join query
Goto Forum:
  


Current Time: Fri Dec 09 03:51:09 CST 2016

Total time taken to generate the page: 0.27309 seconds