Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

string should select multiple tag's

user51685Feb 12 2011 — edited Feb 12 2011
Dear All
my issue is , This is a form tag enquiry form query whcih should retrieve multiple tag number's, but it is showing only one tag number for the below query.
:tag_no := x.tag_number; on this para meter is should select all the tag number's from the request number.
:description := x.item_desc
:current_location := x.move_location ;
:last_location := x.tag_location ;
:mcr_no := x.request_number;
:technical_data := x.technical_data;

my concern is that it should select as many as tag's assosciated with the request number's
:tag_no := x.tag_number; it is showing only one tag, how should i change so that it display all the tag number's.



regards
arifuddin

Edited by: user11309801 on Feb 12, 2011 11:37 AM

Edited by: user11309801 on Feb 12, 2011 12:05 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 12 2011
Added on Feb 12 2011
1 comment
108 views