Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > SQL Language
| Search | Today's Posts | Mark Forums Read
SQL Language SQL Language discussions not specific to a particular RDBMS program or vendor.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Language section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old July 27th, 2005, 11:25 AM
Registered User
 
Join Date: Jul 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default retrieving multiple rows from table

i ve a table in a oracle database. i want to create a stored procedure to retrieve multiple rows depending upon the input info..assume xxx and yyy are in table

Code:
create or replace procedure proc_name(data_in IN varchar, data_out OUT) as BEGIN select xxx INTO data_out from table_name where yyy=data_in;end;
wat if when i ve multiple data_in that matches yyy...how to retrieve all of them and corresponding rows..
pl help.

thanks in advance.

  #2 (permalink)  
Old August 8th, 2005, 03:55 AM
Authorized User
 
Join Date: Jan 2005
Location: Delhi, Delhi, India.
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi you have post the answer in wrong section,
you should post thi in oracle section.....

But in SQL Server by using table variable you can complete the task.

Amit Jain

Amit Jain
Sr. Software Engineer


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving Data From Multiple Databases Macsood SQL Language 4 January 24th, 2012 04:58 AM
INSERT multiple rows to a table nvillare Oracle 7 November 3rd, 2007 04:47 AM
Retrieving items from a table - Immediate Help badprogrammer Access VBA 2 May 4th, 2005 02:39 PM
print multiple times..multiple rows... abhit_kumar JSP Basics 3 January 18th, 2005 07:11 PM
Updating multiple Rows from multiple fields in ASP vdm_nana SQL Server ASP 0 April 1st, 2004 04:26 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.