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 vote280 views1 answer
Sql server count all tables rows
SQL
0 vote284 views2 answers
Sql update multiple tables
SQL
51 votes625 views6 answers
Installing mysql on ubuntu
SQL
0 vote273 views1 answer
Mysql auto increment in DD-MM-XXX format
SQL
0 vote287 views1 answer
Sql server system messeges
SQL
1 vote313 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote301 views1 answer
Selecting duplicates
SQL
2 votes305 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
31 votes278 views3 answers
Sql count(*)
SQL
0 vote271 views1 answer
Implicit inner join table alias with id values
SQL