| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: running sqlplus scripts from http location [was: DBA needed in Austin, TX]
Hi!
I once posted this trick on comp.databases.oracle.server newsgroup:
SQL> @http://localhost:7778/rinit.sql
@http://localhost:7778/&1
SQL> @r instance.sql
TIME USER INSTANCE_NAME HOST_NAME
----------------- ---------- ---------------- ---------- 20030815 03:04:14 ADMIN orcl PORGAND
SQL> I have a script named instance.sql in my web location and rinit.sql contents are very simple:
set define \
spool r.sql
prompt @http://localhost:7778/&1
spool off
set define &
The only problem is that you have to type .sql in the end of script name, but I do mostly anyway. Also, if you want to give parameters to your sql script from command line, you might have to modify rinit script
Cheers,
Tanel.
I had the same thought about SQLPATH. That would make this very useful indeed.
Steve Rospo <srospo_at_watchmark.com>
Sent by: ml-errors_at_fatcity.com
09/25/2003 12:04 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: DBA needed in Austin, TX
Did you leave off a :-)? I remember plenty of 100% (or at least high 90s') days back in Troy/Albany. When I moved to Seattle I had to explain what 100% humidity was or what the weather man meant by "good sleeping weather". Don't miss the summers, but I do miss the foliage...
ObOracle: Best tidbit from Connor's 9i "Forgotten" Features
URL's for scripts
SQL> @http://script.repository/scripts/sessions.sql
I'm sure there's something cool I could do with that but in order to be *REALLY* useful I'd want to be able to do this....
export SQLPATH=$HOME/sql:http//script.repository/scripts/
..or something like that. The : in the http: is a problem. Of course I'd *never* point this out to somewhere out on the big, scary Internet! To easy for some script kiddy to hack.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tanel Poder
INET: tanel.poder.003_at_mail.ee
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 25 2003 - 18:09:41 CDT
 |
 |