Re: please read me...

From: Matt Brennan <mbrennan_at_gers.com>
Date: Wed, 06 May 1998 22:48:10 GMT
Message-ID: <01bd7941$050b3e60$049a0580@mcb>

Are you asking or telling? If asking, you can execute a UNIX command within SQL*Plus by preceding it with a '!'. Example:

spool myfile.dat
select 'X' from dual
/
spool off
!cp myfile.dat myfile.dat.$$

The few times it doesn't seem to work right is if you are setting a variable with a UNIX command to be used in a subsequent command - it doesn't "stick". If there *is* a way, I don't know how to do it.

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com

N&TS <netsw_at_tin.it> wrote in article
<01bd78fe$25507ca0$2701a8c0_at_maurizio.nets>...
> it.s possible execute a command unix form PL/SQL
Received on Wed May 06 1998 - 17:48:10 CDT