Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle's ? = SQL Server's stored procedure ???

Re: Oracle's ? = SQL Server's stored procedure ???

From: Rob Calfee <trace_at_primenet.com>
Date: 2000/03/06
Message-ID: <8a0lud$is3$1@nnrp02.primenet.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US