Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

Use IN for number value

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> 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> 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> drop table promotion; Table dropped. SQL>