Mega Code Archive

 

Categories / Oracle PLSQL / Table

 

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>