SQL statement errors

I have a problem with an SQL statement. I'm trying to create a table and in two columns i use the default option with either SYSDATE or USER

CREATE TABLE depot(
 DEPOT_ID NUMBER(4) NOT NULL,
 COMPANY_NAME VARCHAR2(30) NULL,
 STREET_ADDRESS VARCHAR2(60) NULL,
 CITY VARCHAR2(30) NULL,
 STATE VARCHAR2(2) NULL,
 ZIPCODE VARCHAR2(9) NULL,
 TELEPHONE VARCHAR2(10) UNIQUE,
 FAX VARCHAR2(10) NULL,
 PRIMARYCONTACT_NAME VARCHAR2(30) NULL,  CREATED_DATE DATE default sysdate not null,  CREATED_BY VARCHAR2(30) default user,  MODIFIED_DATE DATE NULL,
 MODIFIED_BY VARCHAR2(30) NULL,
 CONSTRAINT PK_DEPOT PRIMARY KEY(DEPOT_ID) );

The syntax error seems to be the default option using SYSDATE or USER. Can you use these pseudocolumns in the default option?

Jim Received on Fri Mar 13 1998 - 00:00:00 CST