OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » unix help

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

unix help [message #57840]

Thu, 10 July 2003 10:33

sidd
Messages: 130
Registered: May 2003

Senior Member

i want to delete the first 2 lines that start with
SQL> SPOOL
ENTER THE DATA:XXXX
and i do want to delete the last line that start with SQL> SPOOL OFF. how do i this.

Report message to a moderator

Re: unix help [message #57841 is a reply to message #57840]

Thu, 10 July 2003 11:49

Navtej
Messages: 19
Registered: July 2003

Junior Member

sqlplus -s scott/tiger << eof >test
set feedback off
set pages 0
select * from emp;
EOF

OUTPUT written in TEST file

Report message to a moderator

Re: unix help [message #57843 is a reply to message #57841]

Thu, 10 July 2003 12:43

sidd
Messages: 130
Registered: May 2003

Senior Member

Thank very much, i want to do on unix side though.

Report message to a moderator

Re: unix help [message #57844 is a reply to message #57843]

Thu, 10 July 2003 14:21

Joe
Messages: 138
Registered: November 1999

Senior Member

sidd,
you need to use an editor like 'vi' or 'emacs'...try typing:

unix> man vi

Report message to a moderator

Re: unix help [message #57846 is a reply to message #57844]

Thu, 10 July 2003 14:42

sidd
Messages: 130
Registered: May 2003

Senior Member

Thanks men, it works with man vi

Report message to a moderator

Previous Topic:	Index Extents
Next Topic:	procedure overload

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 04:59:20 CDT 2024