Create table with three columns
SQL> CREATE TABLE customers
2 (
3 id NUMBER,
4 credit_limit NUMBER,
5 email VARCHAR2(30)
6 );
Table created.
SQL>
SQL>
SQL> select id, credit_limit
2 from customers
3 where id = 28983;
no rows selected
SQL>
SQL> drop table customers;
Table dropped.
SQL>
SQL>
Related examples in the same category