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 based on a column value

978734Dec 15 2012 — edited Dec 17 2012

I just wanted to know the correct syntax for deleting a selective row. For example, if there's a column in a table where the values are between 100 and 300. How can I delete the row where the column has values lower than 200?

SELECT sc_status
FROM o_weblog 
WHERE sc_status < 200;

All this shows me is an empty column.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2013

Added on Dec 15 2012

#oracle, #sql

5 comments

1,650 views