Add new column with default value and not null : Add Column « Table « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Table
3. Add Column

SQL> create table registrations
  2  ( attendee    NUMBER(4)
  3  , course      VARCHAR2(6)
  4  , begindate   DATE
  5  , evaluation  NUMBER(1)
  6  , constraint  R_PK        primary key (attendee,course,begindate)
  7  ) ;

Table created.

SQL>
SQL>
SQL> alter table registrations
  2  add  (entered_by number(4) default 9 not null);

Table altered.

SQL>
SQL>
SQL> drop table registrations;

Table dropped.