Use of host command from scripted SQL
- From: "David Moss" <David.Moss@xxxxxxxxxxxx>
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 15 Dec 2006 09:27:41 -0000
Hello,
I was playing around with SQL*Plus and found that I could include the
host command in my scripts, being a UN*X person I styarted trying to get
the result of some simple commands (pwd, ls, grep, etc) back into SQL,
but got no joy.
What I'm trying to do is something like:
DEFINE my_var = HOST pwd;
Or
SELECT (HOST pwd) FROM dual;
Or somesuch... Is there a way to do this?
Thnks,
David.
This message is confidential and is intended for the addressee only; unless
clearly stated that this disclaimer should not apply, this e-mail is not
intended to create legally binding commitments on behalf of FDM Group Plc, nor
do its contents reflect the corporate views or policies of FDM. Any
unauthorised disclosure, use or dissemination, either whole or partial, is
prohibited. If you are not the intended recipient of the message, please notify
the sender immediately.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
--
//www.freelists.org/webpage/oracle-l
Other related posts:
