create table null_test (eno number, ename varchar2(20), salary number);
insert into null_test values (1, 'Peter',1000);
insert into null_test values (null, 'john',null);
insert into null_test values (3, null,3000);
commit;
Query Required:
One single select query
select * from null_test where eno = :p_eno ; -- :p_eno when assigned NULL ,I want all three records to get displayed
select * from null_test where eno = :p_eno ; -- :p_eno when 1.I want all one record with eno 1 should get displayed
same for varchar2 fields ename
Regards,
Vinodh