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

1 vote253 views2 answers
Truncate table sqlite
SQL
0 vote236 views1 answer
Postgres get database encoding
SQL
1 vote230 views1 answer
How to delete a record from sqlite in android
SQL
4 votes226 views2 answers
Error loading MySQLdb module.
SQL
0 vote231 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
1 vote219 views1 answer
Stop mysql server mac
SQL
1 vote231 views1 answer
Sql where last 12 months
SQL
9 votes223 views2 answers
Convert data type in sql
SQL
0 vote230 views1 answer
Complete date is 1 year or not sql server
SQL
2 votes221 views1 answer
Sql count having
SQL