By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,346 Members | 2,339 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,346 IT Pros & Developers. It's quick & easy.

MS ACCESS to PL/SQL converter

P: 8
Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL
Feb 7 '07 #1
Share this Question
Share on Google+
6 Replies


100+
P: 1,646
Hi. I am curious about the use of the word 'macro' in this context. What, exactly, do you want to port?
Feb 7 '07 #2

MMcCarthy
Expert Mod 10K+
P: 14,534
Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL
As willakawill says it all depends on what the macro is doing. A lot of macro functionality won't have an equivalent oracle/sql command. If you tell us what the macro is doing we may be able to give you a better idea.
Feb 8 '07 #3

P: 8
As willakawill says it all depends on what the macro is doing. A lot of macro functionality won't have an equivalent oracle/sql command. If you tell us what the macro is doing we may be able to give you a better idea.
Thanks for ur response....its a macro which when executed, runs a list of SQL queries written in MS access.

Now i have to write these MS access queries to PL/SQL procedures...though the syntax is more or less similar in structure.....if i have any converter tool...i can cross verify the syntax and help me

To put it staright....i need the name of any tool...which will convert MS aCCESS sQL queries to Pl/SQL
Feb 8 '07 #4

100+
P: 1,646
If you go to each query in Access, switch to design mode and, on the menu, click view|sql you will see the sql syntax that you need.
Feb 8 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks for ur response....its a macro which when executed, runs a list of SQL queries written in MS access.

Now i have to write these MS access queries to PL/SQL procedures...though the syntax is more or less similar in structure.....if i have any converter tool...i can cross verify the syntax and help me

To put it staright....i need the name of any tool...which will convert MS aCCESS sQL queries to Pl/SQL
Unless the queries contain access functions that are not standard aggregate they shouldn't require any conversion.
Feb 8 '07 #6

NeoPa
Expert Mod 15k+
P: 31,494
Hi,

Currently im working on implementing a MS ACCESS macro functionality to Oracle Pl/SQL package. I need to know if there are any tools available for MS ACCESS to Oracle Pl/SQL or SQL. I need it for reference purpose....for checking for syntax etc....since Im new to Oracle Pl/SQL
I guess no-one here knows of any such tools or reference :(
Have you tried asking in the Oracle forum?
Feb 8 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.