Insert value for specific columns : Insert « Insert Update Delete « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Insert Update Delete
3. Insert

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>
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>
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>
SQL>
SQL>