Re: Does Oracle support multiple result sets

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 - 06:05:07 CDT