Link to home
Start Free TrialLog in
Avatar of Sudees
SudeesFlag for Canada

asked on

Best way to find some value from OBJECT TYPE TABLE

create or replace TYPE r_type  FORCE AS RECORD
                   (
      Code NUMBER(15),
      Description NUMBER(15));


create or replace procedure t1 as
      TYPE tr_type IS TABLE OF r_type;
      tr_type_i tr_type;
begin
      r_type(1).code := '1';
      r_type(1).description := 't1';

      r_type(2).code := '1';
      r_type(2).description := 't1';

      r_type(3).code := '1';
      r_type(3).description := 't1';
end;

If I want to search for code 4 in r_type.code column as is it exist or not .

What is the best way to do that

Thanks and Regards
ASKER CERTIFIED SOLUTION
Avatar of Sean Stuber
Sean Stuber

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sudees

ASKER

Thanks for your effort..