Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's ? = SQL Server's stored procedure ???
Yes, You can use cursors to create more than one recordset. Although, to give an explanation is beyond the scope of this message. Check out Steve Feuerstein's Oracle PL/SQL Programming for more details or consult your online doc.
Rob Calfee
Systems Consultant
Quest Software
rcalfee_at_quest.com
xiaomh <xiaomh_at_hotmail.com> wrote in message
news:8a0ep5$91a$1_at_news.gov.on.ca...
> Does anyone know what's the simliar object in Oracle to stored procedure
in
> SQL Server,
> I mean:
> In SQL Server, you can get two recoredset in one stored procedure, for
> example:
> create procedure myTest
> as
> select * from jobs
> select * from employees
>
> How can I do this in Oracle? It seems to me in Oracle's stored procedure,
I
> can only use DELETE, UPDATE or INSERT. Should I use CURSOR to realize this
> purpose?
>
> Thanks in advance.
>
>
>
>
Received on Mon Mar 06 2000 - 00:00:00 CST
![]() |
![]() |