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

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL

Re: PL/SQL

From: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/05/11
Message-ID: <8fegji$2mu$1@nnrp1.deja.com>#1/1

In article <958047457.1680146344_at_news.club-internet.fr>,   BLANC Philippe <blancphi_at_club-internet.fr> wrote:
> Le mer, 10 mai 2000, James Efurd a écrit :
> >I am new to Oracle and am trying to work in PL/SQL on v8.1.5.
> >
> >Is there any way (in PL/SQL) to access the command line for Unix or
 NT?
> >I am looking for any information on how to do this, either through
> >staight PL/SQL or even through an external language if need be.
> >
> >I would appreciate any help.
> >
> >James
> in sqlplus you can prefix your command by $
> ex : $dir
> Philippe.
>

Actually the sqlplus command to pass commands to the OS is "host" which on most UNIX systems may be abbreviated by default as "!" . The only systems where the default abbreviation is "$" that I am aware of are under OpenVMS though I believe you can set this.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu May 11 2000 - 00:00:00 CDT

Original text of this message

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