SQL>
SQL> CREATE TABLE myTable (
2 name VARCHAR2(25),
3 price NUMBER(4,2),
4 start_date DATE);
Table created.
SQL>
SQL> INSERT INTO myTable VALUES (NULL, 2.5, '29-JUN-04');
1 row created.
SQL>
SQL> INSERT INTO myTable VALUES ('Product Name 3', null, '10-DEC-05');
1 row created.
SQL>
SQL> INSERT INTO myTable VALUES (NULL, NULL, '31-AUG-06');
1 row created.
SQL>
SQL> SELECT * FROM myTable;
NAME PRICE START_DAT
------------------------- ---------- ---------
2.5 29-JUN-04
Product Name 3 10-DEC-05
31-AUG-06
3 rows selected.
SQL>
SQL> drop table myTable;
Table dropped.
SQL>