How to output result of SELECT statement which is executed using native dynamic SQL?

by

If you are on Oracle 12c with a 12c client, this should work:

declare
    rc sys_refcursor;
begin
    open rc for 'select * from dual';
    dbms_sql.return_result(rc);
end;

More Related Contents:

  1. What is the replacement of cursor foreach in oracle pl/sql?
  2. Can you SELECT everything, but 1 or 2 fields, without writer’s cramp?
  3. Printing the value of a variable in SQL Developer
  4. PL/SQL, how to escape single quote in a string?
  5. Oracle PL/SQL – Raise User-Defined Exception With Custom SQLERRM
  6. Passing an array of data as an input parameter to an Oracle procedure
  7. Convert comma separated string to array in PL/SQL
  8. UTL_FILE.FOPEN() procedure not accepting path for directory?
  9. Oracle stored procedure with parameters for IN clause
  10. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  11. Get resultset from oracle stored procedure
  12. ways to avoid global temp tables in oracle
  13. Split function in oracle to comma separated values with automatic sequence
  14. check if “it’s a number” function in Oracle
  15. ORA-06508: PL/SQL: could not find program unit being called
  16. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  17. Create Pivot view in SQL from a SQL table
  18. SQL*Plus how to accept text variable from prompt?
  19. Why doesn’t PL/SQL respect privileges granted by Roles?
  20. if (select count(column) from table) > 0 then
  21. Can We use threading in PL/SQL?
  22. Why cannot I use bind variables in DDL/SCL statements in dynamic SQL?
  23. What is the algorithm used by the ORA_HASH function?
  24. passing in table name as plsql parameter
  25. Reading clob line by line with pl\sql
  26. How to use parameters in a ‘where value in…’ clause?
  27. Why cannot I create triggers on objects owned by SYS?
  28. No more data to read from socket
  29. automating rollback script oracle
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment