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 votes208 views2 answers
Sql query to get the number of rows in a table
SQL
0 vote281 views8 answers
Sql to c# linq converter online
SQL
0 vote192 views1 answer
Mysql count unique in group statement
SQL
5 votes203 views6 answers
Sql foreign key
SQL
4 votes197 views2 answers
Postgresql default value
SQL
0 vote182 views1 answer
Check index sql server
SQL
1 vote187 views1 answer
How to find median of a column sql
SQL
0 vote229 views1 answer
Mysql limit order by
SQL
0 vote183 views1 answer
Mysql identified by syntax error
SQL
4 votes246 views1 answer
Oracle change nls_date_format permanently
SQL