Avoiding long code
more description:How can I escape this long process:
declare
i_string NUM_ARRAY;
begin
if array.count > 1
then select * from table where txn_id in (1,2,34)
else
select * from table
END;
/
I hope this gives details
0