Is it possible to output a SELECT statement from a PL/SQL block?
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