Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Compare number value with =(equals)

SQL> CREATE TABLE products(   2    id              NUMBER(6),   3    name            VARCHAR2(50),   4    category        VARCHAR2(50),   5    list_price      NUMBER(8,2),   6    min_price       NUMBER(8,2)   7  ); Table created. SQL> SQL> SQL> select id, name, category, list_price   2  from   products   3  where  id = 117; no rows selected SQL> SQL> drop table products; Table dropped. SQL>