Re: Use of host command from scripted SQL

On 12/15/2006 04:27:41 AM, David Moss wrote:

>
> SELECT (HOST pwd) FROM dual;
>
> Or somesuch... Is there a way to do this?
>
> Thnks,
>
> David.

#!/usr/bin/perl -w
use strict;
use Cwd;
use DBI;
my $pwd=getcwd();

The "use DBI;" line is here so that you can execute SQL commands.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l