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 vote240 views1 answer
Update top 100 sql
SQL
1 vote256 views2 answers
Mysql extract month
SQL
0 vote265 views1 answer
Select count concat string sql server
SQL
4 votes259 views2 answers
Postgres update single column
SQL
9 votes237 views2 answers
Default number in sql
SQL
2 votes270 views1 answer
Sqlite3 show columns name
SQL
0 vote274 views1 answer
Postgres row expiration
SQL
18 votes246 views3 answers
Mysql add column with default value
SQL
0 vote265 views2 answers
How to create a table from another table in sql derby
SQL
0 vote279 views1 answer
Insert value in identity
SQL