SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

seek help to format spool file from SQL*PLUS

856156Dec 29 2011 — edited Dec 30 2011

I am running a Unix shell script to call a Oracle 11g SQL script from a Oracle database. In this SQL script, I need to connect to many different remote databases to select data, then sool these records as one big text file to a directory. Then email the file to related Group users. In the spool file, there is a line on the top of each page like this:

DUMMY
----------------------------------------------------------
DB_NAME

I know this is caused by connect to remote database in SQL*PLUS. My connection string is like this:

Conn system/password@Oracle_SID

How can I remove these lines or how to skip these lines into spool file? Please advise. Thanks in advnce. Wish all of you Happy New Year!!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 27 2012

Added on Dec 29 2011

6 comments

617 views