| Command for disabling query output display(@screen) while spooling. [message #175223] |
Thu, 01 June 2006 06:25  |
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  |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
