ive a problem in pl/sql: well, i read my data with a cursor which stands in my function. The problem is that i only now the dmbs.putline command but i want also show the data in a grid! Exists a command for this action?
This is not something you can do in PL/SQL directly. A client tool can select data and display it in a grid in various ways (e.g. HTML tables, GUI grid controls etc.). What you can do easily is write the data to file in CSV (comma-separated values) format, and then open the file in Excel (or some other spreadsheet program). For example:
SET PAGESIZE 0
SELECT deptno||',"'||dname||'","'||loc||'"' from dept
The output written to test.csv looks like this:
Open that in Excel, and you will get a column for each selected column.