SQL>
SQL> CREATE TABLE myTable (
2 name VARCHAR2(25) NOT NULL,
3 price NUMBER(4,2) NOT NULL,
4 start_date DATE);
Table created.
SQL>
SQL> INSERT INTO myTable VALUES ('Product Name 1', 1, NULL);
1 row created.
SQL>
SQL> SELECT * FROM myTable;
NAME PRICE START_DAT
------------------------- ---------- ---------
Product Name 1 1
SQL> drop table myTable;
Table dropped.
SQL>
SQL>
|