Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Convert Mysql table schema to Oracle table

Convert Mysql table schema to Oracle table

From: Angsql <angsql_at_gmail.com>
Date: 22 Mar 2006 14:17:54 -0800
Message-ID: <1143065873.894980.116690@u72g2000cwu.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US