Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 45
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
Report message to a moderator
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: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
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: 45
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.
Report message to a moderator
Re: SQLPLUSW spooling [message #316410 is a reply to message #316407 ] Fri, 25 April 2008 00:53 Go to previous message
Michel Cadot
Messages: 15244
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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
Report message to a moderator
Previous Topic:How To Display XMLTYPE datatype contents in SQL* PLUS
Next Topic:how to not display substitutions in a spool file
Goto Forum:
  

[ Syndicate this forum (XML) ] [ ]

Current Time: Sat May 17 03:30:45 CDT 2008

Total time taken to generate the page: 6.33026 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.