I have a simple oracle SQL as below
select distinct table_name from user_tab_columns where table_name like ‘%’||table_like||’%’ order by table_name;
I created a procedure with a VARCHAR2 parameter as an input value for table_like above.
I can use DBMS_OUTPUT.PUT_LINE to print the result but it only shows on DBMS output panel.
Is there a way I can make some changes to directly display the results to Toad’s data grid panel?
Any sugggestion is appreciated.