Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: running sqlplus scripts from http location [was: DBA needed in Austin, TX]

Re: running sqlplus scripts from http location [was: DBA needed in Austin, TX]

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Thu, 25 Sep 2003 15:09:41 -0800
Message-ID: <F001.005D1159.20030925150941@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US