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 vote152 views1 answer
Mysql delete from where like
SQL
5 votes137 views1 answer
How to check nls format in oracle
SQL
0 vote212 views1 answer
Sql if clause within where clause
SQL
3 votes142 views3 answers
How to add month in update sql
SQL
1 vote133 views1 answer
Mysql show table character set
SQL
0 vote141 views2 answers
Sql query in dax power bi
SQL
0 vote178 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote131 views1 answer
Sql character index
SQL
0 vote173 views1 answer
Get first monday of month sql
SQL
0 vote129 views2 answers
How to set global time_zone in mysql
SQL