To make the requirement simple....If I have a proper value present in arguments... I have to select the data accordinlgy using the where condition. and if i have null value present in the arguments..I should get the whole data in table without checking any condition in where clause. Please do help me. THanks.
create or replace procedure get_tt_rule_1
v_t_cde char default null
,v_st_cde char default null
,v_carr char default null
,cur1 IN OUT gpkg.cur
open cur1 for
from R_rule A
(v_t_cde is null or A.t_cde = v_t_cde)
and ( v_st_cde is null or A.st_cde = v_st_cde)
and (v_carr is null or A.carr = v_carr);
You do not need a parachute to skydive. You only need a parachute to skydive twice.