Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Compare number value with != (not equals)

SQL> CREATE TABLE products   2  (   3    id              NUMBER(6),   4    name            VARCHAR2(50),   5    descr            VARCHAR2(4000),   6    subcategory     VARCHAR2(50),   7    subcat_desc     VARCHAR2(2000),   8    category        VARCHAR2(50),   9    weight_class    NUMBER(2)  10  ); Table created. SQL> SQL> SQL> SQL> select id, category, weight_class   2  from   products   3  where  weight_class != 1; no rows selected SQL> SQL> SQL> drop table products; Table dropped. SQL>