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

6 votes165 views1 answer
Check Table Exists
SQL
2 votes170 views1 answer
How to select from mssql
SQL
0 vote153 views2 answers
Mysql row_number() example
SQL
0 vote135 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
2 votes132 views4 answers
Mysql select into new table
SQL
1 vote131 views1 answer
ORA-01950
SQL
1 vote169 views1 answer
Insert many to many sql
SQL
1 vote85 views1 answer
Python escape string for sql
SQL
0 vote140 views2 answers
Close external port 3306 with iptables
SQL
0 vote138 views1 answer
Min varias colunas spark sql
SQL