MySQL Forums
Forum List  »  Oracle

Oracle PL/SQL to MySQL SQL conversion.
Posted by: Bill McNamara
Date: December 04, 2008 07:00AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Oracle PL/SQL to MySQL SQL conversion.
6594
December 04, 2008 07:00AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.