Re: Is there anyway to work on the connection object

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: 13 Dec 2004 05:19:18 -0800
Message-ID: <1102943958.115966.249400@f14g2000cwb.googlegroups.com>

arzhan laster via OracleMonster.com wrote:
> Is there anyway to work on the connection object from SQL window? I'm
trying to work on the performance of the queries I'm executing.
> I connect to Oracle from SQL window and wanto use this connection
object (if possible) and work on it (if possible)if there are methods available supporting this.

Could you give us a clue as to what environment you are using? What is the SQL window?

> Using SQL can I assign the result of a particular query to a variable
like
> int String = select sysdate from dual;

ok this looks like some sort of programming language, except you appear to have an integer variable called string and be assigning a date to it. Possibly its a string variable called int to which you are assigning a date. anyway around it makes no sense.

Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com Received on Mon Dec 13 2004 - 07:19:18 CST