Oracle PL/SQL to MySQL SQL conversion.

[Bill McNamara]

Hi all,

I need to convert the following Oracle PL/SQL to MySQL SQL:

-----------

CREATE TABLESPACE cdrindexes DATAFILE 'CDRINDEXES' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE 500M;

CREATE TABLE CDRTABLE_1(callid VARCHAR2(40) primary key USING INDEX TABLESPACE cdrindexes, cdr CLOB);

CREATE TABLE CALLTABLE1(callid VARCHAR2(40) primary key USING INDEX TABLESPACE cdrindexes, ano VARCHAR2(60), bno VARCHAR2(60), host VARCHAR2(50), starttimemillis NUMBER, stoptimemillis NUMBER, startdate DATE, starttime NUMBER, stopdate DATE, stoptime NUMBER, dtmf NUMBER, recognition NUMBER, naccessedpages NUMBER, eventseq VARCHAR2(200));

CREATE TABLE CDR_SERVICES (callid VARCHAR2(40), tagname VARCHAR2(30), name VARCHAR2(30), startdate DATE, starttime NUMBER, stopdate DATE, stoptime NUMBER, result VARCHAR2(2));

CREATE TABLE CURRENT_TABLE_CDRTABLE_ (current_table VARCHAR2(50));

INSERT INTO CURRENT_TABLE_CDRTABLE_ VALUES ( 'CDRTABLE_1' );


----------------

Can anyone help!?
Thanks,
Bill



Edited 1 time(s). Last edit at 12/04/2008 07:01AM by Bill McNamara.