QueryDef Conversion/Execution

With the Client-Server Edition of Scriptoria, the Ad-Hoc Query form can be used to translate Access queries into Oracle PL*SQL. The translated query is displayed in the Ad-Hoc Query text area where it can be deployed and / or executed.

 

Translating Access QueryDefs into Oracle PL*SQL Example

 

Select a QueryDef from the combo box to translate it to PL*SQL. Check the Include CrLf box to include carriage-returns and line-feeds in the displayed SQL.  Press the button or Alt-g to execute the SQL

 

Results from executing the translated QueryDef