Helpful Information
 
 
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)