|
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.
----- Original Message -----
Sent: Thursday, September 25, 2003 11:19
PM
Subject: RE: DBA needed in Austin,
TX
I had the same thought about
SQLPATH. That would make this very useful indeed.
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.
|
