Re: Oracle doubts

From: DA Morgan <>
Date: Fri, 17 Aug 2007 09:13:05 -0700
Message-ID: <> wrote:
> I would like to know 2 things regarding oracle.
> 1)Does Oracle PL/SQL now support the returning of a recordset to the
> business tier by just using a single 'SELECT ColNameList FROM
> tablename', or still I have to use the cumbersome method of declaring
> a ref cursor etc.?
> If it has not been implemented by Oracle, is there any particular
> reason as to not to implement this, I bet the reason would be to allow
> performance enhancements ,but wouldnt it be nice if Oracle provide
> both implementations and then give a statuatory warning or so.
> 2)Is there any GUI tool(similar to SQL Server Profiler) provided by
> Oracle other than 3rd party tools? I specify that its a GUI tool.
> Thanks,
SQL Server runs on one and only one operating system. Oracle runs, in an identical manner, on every major operating system.

is too much for you to type perhaps you should choose a different profession.

Daniel A. Morgan
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Aug 17 2007 - 18:13:05 CEST

Original text of this message