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!

How to avoid inserting duplicate values into pl sql table

Venkat RakeshFeb 26 2011 — edited Feb 26 2011
Hi all,

I have a pl sql table , Which is defined as below.
 TYPE l_rec_sqr IS RECORD (
         sqr_line_id   xxscp_gbl_sqr_details_tmp.sqr_line_id%TYPE
      );

 TYPE sqr_tab IS TABLE OF l_rec_sqr
     INDEX BY BINARY_INTEGER;

 l_tab_sqr_id                sqr_tab;
While inserting values into sqr_line_id of above table type I should not insert any duplicate values.. So is there in method to check the existance of the value other than using loops. It Will be very much help full for me if i could get any way.

Thanks in advance,
Rakesh
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 26 2011
Added on Feb 26 2011
7 comments
3,677 views