Home » Server Options » RAC & Failsafe » Command for disabling query output display(@screen) while spooling.
Command for disabling query output display(@screen) while spooling. [message #175223] Thu, 01 June 2006 06:25 Go to next message
ranjithacusis
Messages: 1
Registered: June 2006
Location: Bangalore
Junior Member
I am using oracle 10g in my office. For making reports, I am giving a set of queries using .txt file including the output spool file path.

While it is spooling, oracle showing the output in console / screen as well as in the spool files.

But I am searching a command to disable the output display at the console. So I can see the command file given previously without scrolling the console.

Please send me help to following email address:
ranjith.e@acusis.com

Thanks in advance
Ranjith.

[Updated on: Thu, 01 June 2006 06:27]

Report message to a moderator

Re: Command for disabling query output display(@screen) while spooling. [message #175247 is a reply to message #175223] Thu, 01 June 2006 07:05 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
I think this eg should help:

I used windows command prompt for same.


test.sql:

spool test.txt
select * from tab;
spool off;
exit;


Case 1:

Output shown on screen as well.

Quote:

C:\Documents and Settings\grohini.STIN\Desktop>sqlplus scott/tiger@edbms

SQL*Plus: Release 9.2.0.7.0 - Production on Thu Jun 1 17:30:17 2006

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> @test.sql

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
ANIL TABLE
BONUS TABLE
DEPT TABLE
EMP TABLE
SALGRADE TABLE

Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production




Case 2:

No output shown on screen.

Quote:

C:\Documents and Settings\grohini.STIN\Desktop>sqlplus -s -l scott/tiger@edbms @test.sql >testing.txt

C:\Documents and Settings\grohini.STIN\Desktop>


The only lacunae i found in case 2 is that 2 files containing same data gets generated.

Also if you are using delimiter in generating output data, then you can skip the spool caluse from within the sql script.

--Girish

[Updated on: Thu, 01 June 2006 07:06]

Report message to a moderator

Previous Topic: 10g RAC instance order
Next Topic: Difference between RAC and Clusterware?
Goto Forum:
  


Current Time: Thu Mar 28 18:57:52 CDT 2024