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 vote238 views1 answer
Distance calculator from lat long sql query
SQL
5 votes214 views4 answers
Sqlite3.OperationalError: near "WHERE": syntax error
SQL
0 vote189 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote162 views1 answer
Update row in sqlite python
SQL
0 vote334 views1 answer
The differnece between to values in sql
SQL
1 vote201 views1 answer
Oracle case
SQL
3 votes206 views1 answer
How to check schema privileges in oracle
SQL
1 vote193 views2 answers
Populate sql table with random data
SQL
0 vote207 views1 answer
Except in sql
SQL
4 votes205 views3 answers
Sql drop primary key
SQL