oracle-apex – Tarik Billa

Why use Oracle Application Express for web app?

April 26, 2023 by Tarik

Please note my experiences are with APEX 2.x-3.0. I used Apex for a few internal apps over a 12 month period but eventually dumped it for ASP.NET. Some Oracle evangelists claim it is capable of creating highly dynamic content on par with the more mainstream frameworks like ASP.NET/J2EE. Technically this is true, but then technically … Read more

Is it possible to output a SELECT statement from a PL/SQL block?

February 3, 2023 by Tarik

You can do this in Oracle 12.1 or above: declare rc sys_refcursor; begin open rc for select * from dual; dbms_sql.return_result(rc); end; I don’t have DBVisualizer to test with, but that should probably be your starting point. For more details, see Implicit Result Sets in the Oracle 12.1 New Features Guide, Oracle Base etc. For … Read more