How to use Like in SQL different ways
select * from employee
where account_number like '%'||nvl(:p_cust_no,account_number)||'%'
and location like'%'||nvl(:p_loc,location)||'%'
select * from employee
where account_number like '%'||nvl(:p_cust_no,account_number)||'%'
and location like'%'||nvl(:p_loc,location)||'%'
No comments:
Post a Comment