Re: SQL statement errors

From: Robert Prendin <rprendin_at_magi.com>
Date: 1998/03/14
Message-ID: <3509cb3e.715446057@news.istar.ca>#1/1

Jim I just created that table in 8 and works fine, give me more details. perhaps I missed the question.

SQL> CREATE TABLE depot(
  2 DEPOT_ID NUMBER(4) NOT NULL,
  3 COMPANY_NAME VARCHAR2(30) NULL,   4 STREET_ADDRESS VARCHAR2(60) NULL,   5 CITY VARCHAR2(30) NULL,
  6 STATE VARCHAR2(2) NULL,
  7 ZIPCODE VARCHAR2(9) NULL,
  8 TELEPHONE VARCHAR2(10) UNIQUE,   9 FAX VARCHAR2(10) NULL,
 10 PRIMARYCONTACT_NAME VARCHAR2(30) NULL,  11 CREATED_DATE DATE default sysdate not null,  12 CREATED_BY VARCHAR2(30) default user,  13 MODIFIED_DATE DATE NULL,
 14 MODIFIED_BY VARCHAR2(30) NULL,
 15 CONSTRAINT PK_DEPOT PRIMARY KEY(DEPOT_ID)  16 );

Table created.

  1* insert into depot ( DEPOT_ID , TELEPHONE ) values(11,'22') SQL> / 1 row created.

SQL> select CREATED_DATE, CREATED_BY from depot;

CREATED_D CREATED_BY

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

13-MAR-98 TIPSMAN "AccessExcel" <JamesG86_at_email.msn.com> wrote:

>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 Sat Mar 14 1998 - 00:00:00 CST