Not NULL column : NOT NULL « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. NOT NULL

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>