Helpful Information
Home
Categories
Contact us
Category: Oracle Development
NOT IN query
I have given like this...
delete from tmp_Acc ta where ta.pack_cd = 'su' and ta.state_cd not in ('er','rt') and prod_cd not in ('ty','iu');
What should this query do??
Please suggest
Thanks
Delete?
You should really read an "How to post a question" tutorial
I have given like this...
delete from tmp_Acc ta where ta.pack_cd = 'su' and ta.state_cd not in ('er','rt') and prod_cd not in ('ty','iu');
What should this query do??
Please suggest
Thanks
This query delete all rows from table tmp_acc having pack_cd is SU and state_cd not contain value er,rt and prod_cd not contain value ty,iu
privacy (GDPR)