Mega Code Archive
Compare varchar2 value with =
<![CDATA[
SQL> CREATE TABLE products
2 (
3 id NUMBER(6),
4 name VARCHAR2(50),
5 descr VARCHAR2(4000),
6 category VARCHAR2(50),
7 cat_desc VARCHAR2(2000),
8 weight_class NUMBER(2),
9 unit_of_measure VARCHAR2(20),
10 min_price NUMBER(8,2)
11 );
Table created.
SQL>
SQL>
SQL>
SQL> select id, category, weight_class
2 from products
3 where category = 'Hardware'
4 or weight_class = 4;
no rows selected
SQL>
SQL> drop table products;
Table dropped.
SQL>
SQL>
]]>