| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Easy in SQL Server. How do you do this in Oracle?
Hi. I believe that Oracale's PL-SQL and procedures are superior
to MS's T-SQL and procedures. In this one elemental example
you need to do more with PL-SQL. Oracle procedures cannot
act transparently like plain SQL queries, from the perspective of
the client. Oracle procedures can only return query results via
output parameters (cursor type).
HTH,
Joe Weinstein at BEA Systems
Received on Mon May 15 2006 - 16:19:17 CDT
 |
 |