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

31 votes350 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote362 views1 answer
Double in sql server example
SQL
0 vote374 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
5 votes379 views2 answers
Sql conn
SQL
13 votes357 views2 answers
Get tables in database sql
SQL
15 votes366 views4 answers
Export mysql db using command line
SQL
1 vote349 views1 answer
Sql server get users
SQL
2 votes377 views1 answer
Sql string_agg
SQL
0 vote385 views1 answer
For select oracle
SQL
0 vote394 views1 answer
How to print sql query
SQL