sqlplus doing ftp :)

Hi!

Probably some of you already know about it, but I just found out you actually can execute sql scripts which reside somewhere in web:

SQL> @http://www.someurl.com/script.sql

and

SQL> @ftp://ftp.server.com/dir/script.sql

This works for 9.2 command line sqlplus in windows at least :O) This could be quite useful, you just can put your scripts on a webserver and whereever you are, you always can access your stuff directly from sqlplus :) It seems sqlplus doesn't support https and probably no proxy servers either, thus you shouldn't exercise this on public networks without verifying the script contents first.

Also I noticed that, when typing @@@ at sqlplus promt, it tries to execute a "default" sql script. Could be useful for a very commonly used script (though @1 or @a is still faster to type...)

Cheers,
Tanel. Received on Tue Aug 12 2003 - 17:08:24 CDT