Home » Other » Client Tools » Tools to view Access sql into Oracle sql format (oracle 10G)
Tools to view Access sql into Oracle sql format [message #399981] Fri, 24 April 2009 14:33 Go to next message
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 Go to previous message
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%'
Previous Topic: sqldeveloper ORA-01034 and ORA-27101 error
Next Topic: Schema Manager
Goto Forum:
  


Current Time: Fri Mar 29 05:50:04 CDT 2024