| Tools to view Access sql into Oracle sql format [message #399981] |
Fri, 24 April 2009 14:33  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
Dear All,
We got a quite long access sql query which was used to get information FROM linked oracle tables. Now we need to query directly without using access.Since access sql format is different, it is of great interest if any tools exist that could convert the access format to oracle sql format. It would be of great time savings and helpful to understand the query.
Thanks.
|
|
|
|
| Re: Tools to view Access sql into Oracle sql format [message #400354 is a reply to message #399981] |
Mon, 27 April 2009 15:09  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Try a google on "ansi inner outer join oracle translate".
Oracle's free SQL Developer and free Application Express both have functionality to migrate from Acess to Oracle. As far as I know Access uses ANSI SQL that Oracle also supports, but do this to get the actual SQL that Access sends to Oracle:
1) Run the Access query against Oracle.
2) query the Oracle shared pool based on some fragment of the Access query. select SQL_FULLTEXT from v$sql
where parsing_schema_name = '{My-User}'
and upper(SQL_TEXT) like '%DEPT%' |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
