Click here to Skip to main content
15,903,817 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
SQL
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 ;



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

kindly help
Posted
Updated 24-Jul-12 21:02pm
v2
Comments
ssd_coolguy 25-Jul-12 0:32am    
Dude.. if you are using Mysql datatype in Oracle then how it is possible?
ursatish 25-Jul-12 0:45am    
can u please guide me...what changed do i make

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 ...
 
Share this answer
 
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[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900