Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

delete row with null value

Tony007Dec 5 2012 — edited Dec 5 2012
hiw how can i delete a row which got a null value in certain column i try this
DELETE FROM ORGANISATIONS WHERE REGISTRATIONNUMBER = null
but i got 0 rows deleted but the reg column got null value

Edited by: adf0994 on 2012/12/05 12:16 PM

Edited by: adf0994 on 2012/12/05 12:16 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2013
Added on Dec 5 2012
6 comments
7,440 views