Data Type Oracle PLSQL

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.