DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to remove prompt out put

  1. #1
    Join Date
    Jan 2001
    Posts
    191

    how to remove prompt out put

    Hi,

    I am using spool to dump a table.

    Following is sql file.

    set heading off
    set feedback off
    set termout off
    spool &1
    select * from &2..test;
    spool off
    exit

    Following is the spool file

    old 1: select * from &2..test
    new 1: select * from xzhu.test

    xyz2000

    I want to remove following test:

    old 1: select * from &2..test
    new 1: select * from xzhu.test


    Is there any way to do it?

    Thanks.

    xyz2000

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    set verify off
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2001
    Posts
    191
    Thank you very much.

    xyz2000

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width