MySQL Forums
Forum List  »  Oracle

How to convert the sql statement from Oracle to MySQL
Posted by: jenny chen
Date: November 05, 2004 01:18PM

Hi,

I'm running some sql statements to create table in the database. The statements are working fine in Oracle DB server. However, if I run those sql statement in MySQL DB server, it just simply throw the syntax error. Could you please let me know why these sql statement cannot work on MySQL and how to migrate them from Oracle to MySQL?

Thanks in advance for the reply!

Here are the statements:

create table Bigint_Tab (MAX_VAL NUMBER(19,0), MIN_VAL NUMBER(19,0), NULL_VAL NUMBER(19,0) NULL)

create table Binary_Tab (BINARY_VAL RAW(24) NULL)

create table Varbinary_Tab (VARBINARY_VAL RAW(48) NULL)

create procedure Numeric_Proc (MAX_PARAM out NUMBER, MIN_PARAM out NUMBER, NULL_PARAM out NUMBER) as begin select MAX_VAL, MIN_VAL, NULL_VAL into MAX_PARAM, MIN_PARAM, NULL_PARAM from Numeric_Tab; end;

Options: ReplyQuote


Subject
Views
Written By
Posted
How to convert the sql statement from Oracle to MySQL
7003
November 05, 2004 01:18PM


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.