Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Compare number value with

SQL> CREATE TABLE customers   2  (   3     id                NUMBER,   4     address    VARCHAR2(40),   5     postal_code       VARCHAR2(10),   6     city              VARCHAR2(30),   7     state_province    VARCHAR2(40),   8     income_level      VARCHAR2(30),   9     credit_limit      NUMBER  10  ); Table created. SQL> SQL> SQL> select id, state_province, credit_limit   2  from   customers   3  where  state_province = 'UT'   4  and    credit_limit > 10000; no rows selected SQL> SQL> SQL> drop table customers; Table dropped.