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>