SQL question

Hi,

I need to drop several rows in <table> where the field 'name' is set to certain values. I'm currently using a drop statement for each field value. Does Oracle sqlplus allow more than one field value to be specfied in a single command? ie.

SQL>delete from <table>

    where name='X' or name='Y' or name='Z'

?

Thankyou.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 15 2000 - 14:02:48 CDT