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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Does Oracle support multiple result sets

Re: Does Oracle support multiple result sets

From: Jeff <jsouthworth_at_dsitopdog.com>
Date: Thu, 9 Apr 1998 09:22:52 -0400
Message-ID: <6gii1p$22a$1@usenet57.supernews.com>


So what happens when you issue the 2 selects from within a stored proc? Say you want to pass an account number to a stored procedure that pulls info from a customer, orders and product table. How would you do this?

Billy Verreynne wrote in message <6gi9se$om7$1_at_hermes.is.co.za>...
>Jeff wrote in message <6ggef6$s0m$1_at_usenet54.supernews.com>...
>>Was wondering if Oracle supports multiple result sets? Can I pass an
>>account number to a stored procedure, then select * from a customer table,
>>then select * from an orders table. What I'm trying to do is pass an
>>account number and pull the info from the customer and orders table.
>
>
>Not sure what you mean with "multiple result sets". The SQL language does
>not support "multiple data sets" resulting from a single SQL statement.
>
>Multiple data sets (or tables) can be combined with a JOIN. In this case
>every invoice row will also contain all the columns from the customer
table.
>
>Another way to combine more than one data set into a single result set via
>SQL is to UNION the SELECTs. This will however only work if the number of
>columns and datatypes correspond between the SELECTs sets.
>
>What is wrong using two seperate SQL statements, one to supply info from
the
>customer table and one to supply the invoices? I fail to see any real
>technical requirement for trying to do it as a single result set via a
>stored procedure.
>
>regards,
>Billy
>
>
>
Received on Thu Apr 09 1998 - 08:22:52 CDT

Original text of this message

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