Home » SQL & PL/SQL » Client Tools » How to input line to sql script (Solaris 5.9)
How to input line to sql script [message #521228] Sat, 27 August 2011 01:37 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi All,

I want to put some line in my .sql file.
The below is my issue :-
SQL>spool /tmp/Tablespace_Remove.ksh
SQL>echo >#!/bin/ksh---- I want to enter this line to my Tablespace_Remove.ksh
SQL>spool off;


How do I do that?
Please help

Thanks -
P
Re: How to input line to sql script [message #521229 is a reply to message #521228] Sat, 27 August 2011 01:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
PROMPT

Regards
Michel
Re: How to input line to sql script [message #521230 is a reply to message #521229] Sat, 27 August 2011 01:47 Go to previous messageGo to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi,
Is it like :-
SQL>spool /tmp/Tablespace_Remove.ksh
SQL>prompt #!/bin/ksh
SQL>spool off;

Please confirm.

Thanks -
P
Re: How to input line to sql script [message #521233 is a reply to message #521230] Sat, 27 August 2011 02:34 Go to previous message
Michel Cadot
Messages: 58644
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please just try it.

Regards
Michel
Previous Topic: Providing bind variables as values in an insert statement inside PL/SQL block not working ?
Next Topic: format column problem
Goto Forum:
  


Current Time: Sat Aug 02 02:04:10 CDT 2014

Total time taken to generate the page: 0.08571 seconds