Live ORACLE

rem -----------------------------------------------------------------------

rem Filename:   default.SQL

rem Purpose:    Example script to demonstrate DEFAULT column VALUES

rem Date:       25-Apr-2001

rem Author:     Frank Naude, Oracle faq

rem -----------------------------------------------------------------------


DROP TABLE x ;

CREATE TABLE x (
a CHAR,
b NUMBER     DEFAULT 99999,
c DATE,
d VARCHAR2(6))
/


ALTER TABLE x
MODIFY( c DATE     DEFAULT SYSDATE)
/


INSERT INTO x
        (a,
         d)
VALUES     ('a',
         'qwerty')
/


SELECT *
FROM   x
/

--

-- Expected output:

--

--  A          B C           D

--  - ---------- ----------- ------

--  a      99999 25-APR-2001 qwerty

Example script to demonstrate DEFAULT column values