Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Convert Mysql table schema to Oracle table
Hi,
Could anyone help me to convert mysql table schema to oracle table
schema.
enum in mysql is a string OR SET datatype.
CREATE TABLE `builds` (
`id` int(10) unsigned NOT NULL default '0',
`product` varchar(50) default NULL,
`branch` varchar(100) default NULL,
`type` varchar(20) default NULL,
`release` varchar(20) default NULL,
`change_number` int(10) unsigned default NULL,
`build_date` datetime default NULL,
`status` enum('succeeded','failed') default 'succeeded',
`saved` enum('y','n') default NULL,
`build_source` enum('vmware','community') default 'vmware',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Thank you
RA.
Received on Wed Mar 22 2006 - 16:17:54 CST