Displaying Query results using DBMS_OUTPUT
Dear All,
I want to display the results of the query in DBMS OUTPUT.
What is the simplest way to do it?
Presently i am storing the results using SELECT ...INTO in variables and displaying it using DBMS_OUTPUT. Any simple alternatives? Can i display it in tabular format?
If the select statement is having variables, then i can i use it as a PL/SQL statement?
Or i have to use EXECUTE IMMEDIATE to do it?
-Sameer