Output table plsql

SET SERVEROUTPUT ON
     BEGIN
          -- A PL/SQL cursor (google implicit cursor to know more about it)
          FOR cursor1 IN (SELECT * FROM table1)
          LOOP
            DBMS_OUTPUT.PUT_LINE('Column 1 = ' || cursor1.column1 ||
                               ', Column 2 = ' || cursor1.column2);
          END LOOP;
     END;
        /

Source: stackoverflow.com

Similar codes

0 vote45 views1 answer
Less mysql display
SQL
0 vote49 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
1 vote39 views1 answer
Increasing font and zooming in mysql workbench
SQL
15 votes41 views3 answers
Find duplicate keys in mysql
SQL
0 vote40 views1 answer
Wordpress sql change site url
SQL
4 votes40 views1 answer
For loop postgresql
SQL
0 vote41 views1 answer
How to print sql query
SQL
1 vote76 views1 answer
How not to sort by average rating
SQL
0 vote37 views1 answer
Kill a pid redshift
SQL
0 vote40 views1 answer
Mariadb hours between two dates
SQL