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

2 votes129 views3 answers
Postgresql reset auto increment
SQL
0 vote132 views1 answer
Sql delimiter to columns
SQL
0 vote117 views1 answer
Restart sql server command line linux
SQL
7 votes129 views3 answers
Postgre describe table
SQL
0 vote136 views1 answer
Create dump file mysql workbench
SQL
5 votes129 views3 answers
Oracle first day of last year
SQL
0 vote151 views1 answer
Mysql where sum > 0
SQL
11 votes141 views2 answers
Having keyword sql
SQL
0 vote185 views1 answer
Tsql find procedure with name
SQL
0 vote242 views1 answer
How to delete duplicate rows in oracle
SQL