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 vote180 views1 answer
Sql offfset
SQL
0 vote179 views2 answers
Database owner can't create new tables postgres
SQL
0 vote246 views1 answer
Sql filter rows with condition
SQL
2 votes226 views1 answer
Orcale index size
SQL
10 votes220 views2 answers
What is database
SQL
0 vote172 views1 answer
How to count with except in psql
SQL
0 vote172 views1 answer
Sql constarint
SQL
0 vote203 views1 answer
Sql select sum group by id laravel join
SQL
0 vote200 views1 answer
SQLServerException.makeFromDatabaseError
SQL
2 votes208 views2 answers
Storing timezones in postgres
SQL