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

4 votes182 views2 answers
Sql table
SQL
0 vote184 views1 answer
Exectuer myssql .sql
SQL
-2 votes202 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote181 views1 answer
Sql query for getting data with join and count
SQL
3 votes173 views3 answers
Mysql get table size
SQL
0 vote165 views1 answer
Min mysql
SQL
0 vote202 views1 answer
Hour differeence in mysql
SQL
1 vote196 views1 answer
Postgresql define pk sequence next number
SQL
4 votes188 views4 answers
Rollback in sql
SQL
11 votes170 views1 answer
How to get ddl for materialized view
SQL