Home » SQL & PL/SQL » SQL & PL/SQL » Create table invalid syntax
Create table invalid syntax [message #194760] Mon, 25 September 2006 03:01 Go to next message
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?

Re: Create table invalid syntax [message #194762 is a reply to message #194760] Mon, 25 September 2006 03:17 Go to previous messageGo to next message
Littlefoot
Messages: 20891
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?
Re: Create table invalid syntax [message #194765 is a reply to message #194760] Mon, 25 September 2006 03:38 Go to previous messageGo to next message
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...
Re: Create table invalid syntax [message #194775 is a reply to message #194765] Mon, 25 September 2006 04:36 Go to previous message
Littlefoot
Messages: 20891
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.
Previous Topic: Global variable
Next Topic: SQL syntax help
Goto Forum:
  


Current Time: Sun Dec 04 06:26:17 CST 2016

Total time taken to generate the page: 0.13058 seconds