Use IN for number value : Number « SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL Data Types
3. Number

SQL>
SQL> CREATE TABLE promotion(
  2    title_id     CHAR(3)      NOT NULL,
  3    advance      DECIMAL(9,2) NULL    ,
  4    royalty_rate DECIMAL(5,2) NULL);

Table created.

SQL>
SQL>
SQL> INSERT INTO promotion VALUES('T01',10000,0.05);

1 row created.

SQL> INSERT INTO promotion VALUES('T02',1000,0.06);

1 row created.

SQL> INSERT INTO promotion VALUES('T03',15000,0.07);

1 row created.

SQL> INSERT INTO promotion VALUES('T04',20000,0.08);

1 row created.

SQL> INSERT INTO promotion VALUES('T05',100000,0.09);

1 row created.

SQL> INSERT INTO promotion VALUES('T06',20000,0.08);

1 row created.

SQL> INSERT INTO promotion VALUES('T07',1000000,0.11);

1 row created.

SQL> INSERT INTO promotion VALUES('T08',0,0.04);

1 row created.

SQL> INSERT INTO promotion VALUES('T09',0,0.05);

1 row created.

SQL> INSERT INTO promotion VALUES('T10',NULL,NULL);

1 row created.

SQL> INSERT INTO promotion VALUES('T11',100000,0.07);

1 row created.

SQL> INSERT INTO promotion VALUES('T12',50000,0.09);

1 row created.

SQL> INSERT INTO promotion VALUES('T13',20000,0.06);

1 row created.

SQL>
SQL>
SQL> SELECT title_id, advance
  2    FROM promotion
  3    WHERE advance IN
  4          (0.00, 1000.00, 5000.00);

TIT    ADVANCE
--- ----------
T02       1000
T08          0
T09          0

SQL>
SQL>
SQL> drop table promotion;

Table dropped.

SQL>