Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create table with DATE

Re: create table with DATE

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 29 Jul 1999 16:32:03 GMT
Message-ID: <37ab81dc.106348991@newshost.us.oracle.com>


A copy of this was sent to "Finnegan Calabro" <fcalabro_at_aisvt.bfg.com> (if that email address didn't require changing) On Thu, 29 Jul 1999 11:54:07 -0400, you wrote:

>It was my understanding DATE could be used as a normal datatype, but I get
>an error with the following sql command (may or may not be because of the
>DATE command):
>
>create table phase(
>phaseid VARCHAR(10),
>start DATE,
>end DATE));
>
>Thanks!
>Finn
>

invalid column name START -- thats a reserved word.

watch out for END as well -- it'll give you no end of problems :) Its a keyword in plsql.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 29 1999 - 11:32:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US