Home » SQL & PL/SQL » Client Tools » SQLPLUSW spooling
SQLPLUSW spooling [message #316398] Fri, 25 April 2008 00:06 Go to next message
cgk_js
Messages: 48
Registered: December 2005
Member
Hi all, Cool

when i spool using toad or plsql dev, i get the spool output with with respect to the values in it.

when i do with sqlplusw, i get the spool output with respect to
the size being declared in the table.

so, whenever i spool using the sqlplusw, i setup col <colnmane> format <datatype>, for that i need to the know the max value for the individual col.

Can anyone suggest a method so that spooling will be happening
as being done in the toad or plsql dev.

Smile
Thanks
Gopal
Re: SQLPLUSW spooling [message #316401 is a reply to message #316398] Fri, 25 April 2008 00:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is 2 options:
- You use default SQL*Plus setting
- You set explicitly set

If you choose the first option, nothing can be done, it is internal.

Regards
Michel
Re: SQLPLUSW spooling [message #316407 is a reply to message #316398] Fri, 25 April 2008 00:46 Go to previous messageGo to next message
cgk_js
Messages: 48
Registered: December 2005
Member
The second approach, that is finding the max size of the column and setting it in the col <colname> format is ok, for small tables, and for varchar2 datatype.

How can we do it for large tables and also for the values with decimal numbers.

eg
1000000.100
0.111
0.55555555555

Thanks
Gopal.
Re: SQLPLUSW spooling [message #316410 is a reply to message #316407] Fri, 25 April 2008 00:53 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
As it is a manual mode, you have to know the max length for each.
Note that for numbers you can use "set numwidth" (defaulted to 10).

Regards
Michel
Previous Topic: How To Display XMLTYPE datatype contents in SQL* PLUS
Next Topic: visual query builder needed
Goto Forum:
  


Current Time: Sat Dec 10 22:48:37 CST 2016

Total time taken to generate the page: 0.13347 seconds