Home » SQL & PL/SQL » SQL & PL/SQL » how to excute the output from query
icon11.gif  how to excute the output from query [message #290631] Sun, 30 December 2007 23:00 Go to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi gurus,

Thank in advance, Here I need to execute the output which is from query. Can u explain how.

Thanks

Re: how to excute the output from query [message #290632 is a reply to message #290631] Sun, 30 December 2007 23:03 Go to previous messageGo to next message
spmano1983
Messages: 269
Registered: September 2007
Senior Member
Hi,

in sqlplus

spool on

go fine menu->spool->create and give the file name

after that execute your query

spool off.

open given file.you can see your query output

Thanks

Mano
Re: how to excute the output from query [message #290633 is a reply to message #290631] Sun, 30 December 2007 23:05 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Here I need to execute the output which is from query. Can u explain how.
HUH?
Your question/statement is 100% nonsensical, In My Opinion.
The "output from a query" is zero or more records.
What is your mind allows anyone to execute zero or more records?
What does it mean to "execute" a record?
What problem are you really trying to solve.

Please read & FOLLOW the posting guidelines for this forum.
Re: how to excute the output from query [message #290642 is a reply to message #290631] Mon, 31 December 2007 00:22 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's an example with a script that gives you the row count of all your tables:
Set heading   off
Set feedback  off
Set pagesize  0
Set termout   off
Set trimout   on
Set trimspool on
Set linesize  100
Spool tmp
Select 'Select '''||table_name||' : ''||count(*) from '||table_name||';'
from user_tables
order by table_name
/
Spool off
Set termout on
@tmp.LST

Regards
Michel
Previous Topic: PLS-00306: wrong number or types of arguments in call to 'QDA_TBL'
Next Topic: merge causes problem in distributed environment (merged)
Goto Forum:
  


Current Time: Sat Dec 10 16:44:55 CST 2016

Total time taken to generate the page: 0.07792 seconds