create table help

From: "srs2000" <srs2000_uk(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: create table help
Date: 2002-02-25 10:04:21
Message-ID: 3c7a0c29_1@mk-nntp-1.news.uk.worldonline.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi im new to sql, and i am trying to use sqlplus.

here's the table im trying to create

create table CUSTOMER

(CUST_NAME varchar2 (14),

CUST_DOB date,

CUST_ADDRESS varchar2 (25)

CUST_TELNO varchar2 (15)

primary key (CUST_NAME, CUST_ADDRESS));

this is the error message i get:

ERROR at line 2:
ORA-00922: missing or invalid option

any suggestion or help, would be much appriciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stefan Weiss 2002-02-25 10:19:26 Fulltext Index and Search
Previous Message Robert Lummert 2002-02-25 09:56:58 Re: setting up a trace through extended stored procedures