Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> spool out on oracle 8 sql

spool out on oracle 8 sql

From: mh579 <mh579_at_bluecarrots.com>
Date: 2000/03/26
Message-ID: <38de67fa_3@news2.vip.uk.com>#1/1

I have transferred several sql scripts form an oracle 7.3.4 database on sco unix to oracle 8 on NT.

Some of the scripts print direct to the printer using spool temp.......spool out, but this seems not to work on oracle 8 sql. The script runs on screen but there is no printout....are there different commands for printing....

Also

the above script also puts the database user (uname) on the report. This is obtained by the command !uname in the sql script. Again this does not work on NT. Can anuone please advise on the command require to get the user name ie DOM_USER Received on Sun Mar 26 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US