ORA00922:无效或缺少选项 [英] ORA00922:invalid or missing option

问题描述

CREATE TABLE IF NOT EXISTS `target_details` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`uid` varchar(25) NOT NULL,

`month` varchar(25) NOT NULL,

`year` varchar(25) NOT NULL,

`ms_target` mediumtext NOT NULL,

`hsd_target` mediumtext NOT NULL,

`alpg_target` mediumtext NOT NULL,

`lubes_target` mediumtext NOT NULL,

`tyres_target` mediumtext NOT NULL,

`rcare_tyres_target` mediumtext NOT NULL,

`rcare_lubes_target` mediumtext NOT NULL,

`rcare_spares_target` mediumtext NOT NULL,

`rcare_service_target` mediumtext NOT NULL,

`afs_target` mediumtext NOT NULL,
  PRIMARY KEY (`id`)
)
ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

在蟾蜍上执行此查询时..... m得到错误ORA00922:无效或缺少的选项

请帮助

on executing this query in toad.....m getting the error ORA00922:invalid or missing option

kindly help

推荐答案

我将首先阅读Oracle的 ^ ]，
然后是Oracle的数据类型 [

I''d start by reading the docs for Oracle''s Create Table[^],
and then Oracle''s DataTypes[^]

You''ll probably fix your problem AND learn something ...

嘿，请看下面的链接..
它具有Mysql和Oracle数据类型之间的比较..to您可以轻松地将其转换为Oracle.

http://docs.oracle.com/cd/B10501_01/win.920/a97249/ch3.htm [ http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm [

Hey have look on below link..
it has comparison between Mysql and Oracle Data Types..to You can easily convert it in to Oracle.

http://docs.oracle.com/cd/B10501_01/win.920/a97249/ch3.htm[^]

and for auto increment yo need to cerate sequence..

http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6015.htm[^]

这篇关于ORA00922:无效或缺少选项的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！