I am using Toad for Oracle 22.214.171.124 Base Edition against Oracle server 11g (126.96.36.199).
I have two questions.
I am looking for a way to convert SQL statements written using Oracle’s pre-ANSI92 join syntax to ANSI92 syntax and vice-versa. Does Toad provide a way to do this? Also, may this be done against many such statements automatically without my having to convert each one individually/manually one-by-one?
Is there a way to access APEX from within Toad. I do not mean simply SELECTing from APEX related tables/views in the APEX schema that is created by default when Oracle was installed. Instead, I ma talking about actually creating and running an APEX application from within Toad.