OraFAQ Forum: Client Tools » How to input line to sql script

Home » Other » Client Tools » How to input line to sql script (Solaris 5.9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to input line to sql script [message #521228]

Sat, 27 August 2011 01:37

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

Report message to a moderator

Re: How to input line to sql script [message #521229 is a reply to message #521228]

Sat, 27 August 2011 01:42

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

PROMPT

Regards
Michel

Report message to a moderator

Re: How to input line to sql script [message #521230 is a reply to message #521229]

Sat, 27 August 2011 01:47

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

Report message to a moderator

Re: How to input line to sql script [message #521233 is a reply to message #521230]

Sat, 27 August 2011 02:34

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please just try it.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 00:11:26 CST 2025