OraFAQ Forum: SQL & PL/SQL » Create table invalid syntax

Home » SQL & PL/SQL » SQL & PL/SQL » Create table invalid syntax

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create table invalid syntax [message #194760]

Mon, 25 September 2006 03:01

tores
Messages: 4
Registered: September 2006

Junior Member

create table "abundance"
(
"abundanceID" Counter not null ,
"sampleID" LongInteger default 0 not null ,
"mesh" Double ,
"opening" Double ,
"filteredWater" Double ,
"depthFrom" Double ,
"depthTo" Double ,
"icefloraRadiation" Double default 0 ,
"icefLoraIceThickness" Double default 0 ,
"analysisDate" LongInteger default 0 ,
"analysisTime" LongInteger default 0 ,
"comment" Memo ,
primary key "abundanceID"
);

"mesh" Double ,
ORA-00905: missing keyword

What keyword is missing?

Report message to a moderator

Re: Create table invalid syntax [message #194762 is a reply to message #194760]

Mon, 25 September 2006 03:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'd rather say that we are talking about the wrong database, not missing keyword. If I remember well, "memo" etc. aren't valid Oracle datatypes, but (perhaps) Access or some other database.

By the way, you are aware of the fact that this is Oracle forum, right?

Report message to a moderator

Re: Create table invalid syntax [message #194765 is a reply to message #194760]

Mon, 25 September 2006 03:38

tores
Messages: 4
Registered: September 2006

Junior Member

Well, yes I am.

But this SQL syntax were created by a program (not written by me), that supposedly creates the corresponding Oracle SQL from an Access database...

Report message to a moderator

Re: Create table invalid syntax [message #194775 is a reply to message #194765]

Mon, 25 September 2006 04:36

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps it is supposed to do what you've said, but, obviously, it does not. This is NOT a valid Oracle CREATE TABLE syntax, and that's it.

This is Oracle Create table command syntax, while this document talks about Oracle data types.

Just a tip: there's no data type like "counter" in Oracle - you'll have to simulate it using a sequence and a database trigger.

Report message to a moderator

Previous Topic:	Global variable
Next Topic:	SQL syntax help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 12:21:56 CST 2024