OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » sql script (oracle 10g)

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

sql script [message #408057]

Sat, 13 June 2009 07:48

pointers
Messages: 451
Registered: May 2008

Senior Member

Hi,

please give me some idea on the below case.

i have 2 queries.
say,

select * from emp

select * from dept

case 1: i want to create an sql script to run from sql * plus, which creates the two result sets in two seperate excel files
and
case 2: other script two get the two result sets in to one excel files.

Please give me an idea or point to me to a document where i can get the idea for my above two tasks

Regards,
Pointers.

Report message to a moderator

Re: sql script [message #408058 is a reply to message #408057]

Sat, 13 June 2009 08:04

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

case1) Just use separate spool files.

 spool file1.csv
  run 1.sql
  spool off
  spool file2.csv
  run 2.sql
  spool off

case2). Just use spool append .
Append the output of second query to spool file from first query.
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12043.htm#sthref3036

Report message to a moderator

Re: sql script [message #408090 is a reply to message #408057]

Sat, 13 June 2009 13:43

pointers
Messages: 451
Registered: May 2008

Senior Member

thanks for your reply Mahesh.....
i will execute all those given by you.....
--pointers`

Report message to a moderator

Previous Topic:	PLS-00222 error
Next Topic:	Dynamic Record In PL/SQL

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 02:27:25 CST 2025