I am no sql or intralink guru, but I have a little to add.
By the way, thanks for the toad link, I will use it once I get
back to work...ha..ha
My add is: I wrote a java gui to query oracle &/or Intralink.
No, I'm not a java guru either. I just try to make all work.
It has a few drop-downs for sql to:
few oracle tuning/monitoring
It could be a good start. No commits, just queries, so it should
not be dangerous for a beginner (which I am still).
IN the above shown folder on my web site, you can use the jar,
complie the java & go form there.
You just enter/modify the URL string:
with your host-name:port:SID.
All this info can be obtained from your tnsnames.ora (usually
located ion your .proi folder or near there).
Then enter user name & pass word (system/manager usually works).
Then select from drop downs: