Just trying to get my query results of a function into normal grid format in SQL Developer to start.
However, my output is stuffed into a single column when I run it from a select() from dual. Even though the output variables window shows output formatted just fine in grid format.
I’m running a function like this:
SELECT function_with_sql(sysdate) from dual;
The function has a cursor defined like this:
RETURN sys_refcursor
AS o_cursor SYS_REFCURSOR;
Begin
open o_cursor for
select……………
Return o_cursor;
End;
/
How do I get the output formatted in normal grid format?
Thanks!