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