Home » Open Source » MySQL » How to convert ORACLE SQL queries to MYSQL queries!!!
How to convert ORACLE SQL queries to MYSQL queries!!! [message #539907] Thu, 19 January 2012 05:00
shiveclat
Messages: 19
Registered: August 2011
Location: pune
Junior Member
Hi All,
can some please help to achive this as am new to database
I have some set of queries they are in ORACLE 10g SQls.
I need to convert them to my sql queries. is there any way to convert them all together or one by one.
Also there are some stored procedures that as well I wanted to convert to my sql queries.
e.g.

prompt *********************** CREATE TPZ_TRANSACTION_TBL ***********************
CREATE TABLE TPZ_TRANSACTION_TBL
(
TpzTransactionID VARCHAR2(50) CONSTRAINT TPZ_TXN_ID_PK PRIMARY KEY NOT NULL,
ProfileID VARCHAR2(50) CONSTRAINT TPZ_PROFILE_ID_FK REFERENCES TPZ_PROFILE_TBL(ProfileID) NOT NULL,
BeanTaskID VARCHAR2(50) NOT NULL,
TransactionName VARCHAR2(50) NOT NULL,
TxnSubjectName VARCHAR2(50) NOT NULL,
SLATime INTEGER NULL,
NavPriority INTEGER NOT NULL,
Del_Indicator VARCHAR2(1) NOT NULL
)
/
Previous Topic: MySQL database Restroring
Next Topic: to create a C/C++ program that connects to a MySQL server
Goto Forum:
  


Current Time: Wed Jul 30 04:08:32 CDT 2014

Total time taken to generate the page: 0.14584 seconds