Advertisement

01.16.2003 at 03:59AM PST, ID: 20459551
[x]
Attachment Details

sqlplus spool

Asked by kcwang7 in Oracle 3rd Party Tools

Tags: ,

Dear Experts,

set feedback off
set heading off
set pagesize 0
spool abc
select * from customer;
spool off

abc.lst
---------------
SQL> select * from customer;
KC                                     22 MT                                     23
SC                                     22
aa                                     33
cc                                     20
aa                                     22
SQL> spool off

How can I remove "SQL>select * from customer;" &
"SQL> spool off" these two lines??

Thanks!!Start Free Trial
[+][-]01.16.2003 at 05:43AM PST, ID: 7740710

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 05:46AM PST, ID: 7740729

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 07:29AM PST, ID: 7741593

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Oracle 3rd Party Tools
Tags: sqlplus, spool
Sign Up Now!
Solution Provided By: tschofiled
Participating Experts: 4
Solution Grade: A
 
 
[+][-]01.16.2003 at 07:33AM PST, ID: 7741635

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 07:35AM PST, ID: 7741651

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 07:40AM PST, ID: 7741699

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 08:21AM PST, ID: 7742089

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.16.2003 at 01:45PM PST, ID: 7744277

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32