| 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
)
/
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
