Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create table with DATE
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