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 (name, price) VALUES ('Product Name 2', 2.5);
1 row created.
SQL> INSERT INTO myTable (name, price) VALUES ('Product Name 3', 50.75);
1 row created.
SQL> INSERT INTO myTable (price, name) VALUES (99.99, 'Product Name 4');
1 row created.
SQL>
SQL> SELECT * FROM myTable;
NAME PRICE START_DAT
------------------------- ---------- ---------
Product Name 2 2.5
Product Name 3 50.75
Product Name 4 99.99
3 rows selected.
SQL> drop table myTable;
Table dropped.
SQL>