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,
MPL

On 17 ago, 08:15, mplp... (AT) yahoo (DOT) com wrote:
Lot of SQLServer background I guess! ;-)

1. No. But It's not 'cumbersome', it's simply different.
2. SQLDeveloper (free).

HTH

Cheers.

Carlos.

mplpost (AT) yahoo (DOT) com wrote:
SQL Server runs on one and only one operating system.
Oracle runs, in an identical manner, on every major operating system.

If:
"OPEN REFCURSOR FOR"
is too much for you to type perhaps you should choose a different
profession.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

mplpost (AT) yahoo (DOT) com wrote:
ng you can spell.

- --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGxfGvLw8L4IAs830RAvYtAJ46kP84SLk69Bj8kVBdGW kmYbw+HgCfc7GB
EM5/EVFfzh23Mpw44QnQ2YI=
=hezS
-----END PGP SIGNATURE-----