Home » SQL & PL/SQL » SQL & PL/SQL » execution
execution [message #319810] Tue, 13 May 2008 01:58 Go to next message
Mihiroracle
Messages: 18
Registered: May 2008
Junior Member
how to execute DOS command in SQL prompt?
Re: execution [message #319812 is a reply to message #319810] Tue, 13 May 2008 02:01 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Use HOST
Re: execution [message #319852 is a reply to message #319812] Tue, 13 May 2008 03:59 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Or, you might try with a dollar ($) sign (as you are talking about DOS):
SQL> $dir *.log
 Volume in drive M is file sharing 1
 Volume Serial Number is 98A9-A7AE

 Directory of M:\

09.05.2008  08:59            40.142 sqlnet.log
11.04.2008  08:07               290 test.log
27.03.2008  13:06               295 test_when.log
               3 File(s)         40.727 bytes
               0 Dir(s)  135.848.837.120 bytes free

SQL>


P.S. If you wonder why the heck dollar sign and not ... I don't know ... dinar or gulden or pfening etc., it is because DOS is a product of Micro$oft.
Re: execution [message #319854 is a reply to message #319852] Tue, 13 May 2008 04:02 Go to previous message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
Well, every day is a school day! I was not aware of the '$' (knew about the '!' for 'nix of course).
Cheers
Previous Topic: how to write a query
Next Topic: what is autonomous pragma transaction in function and procedure
Goto Forum:
  


Current Time: Thu Dec 08 02:08:05 CST 2016

Total time taken to generate the page: 0.22627 seconds