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 vote236 views1 answer
Psql create usr
SQL
0 vote213 views1 answer
Select odd records sql
SQL
0 vote220 views1 answer
Mysql insert into select with recursive
SQL
5 votes346 views2 answers
Mysql date greater than 30 days
SQL
20 votes203 views2 answers
Mysql bigint max value
SQL
0 vote187 views1 answer
Check if table exists oracle
SQL
10 votes205 views4 answers
Drop primary key
SQL
0 vote156 views1 answer
Microsoft sql server management studio clear cache
SQL
2 votes199 views2 answers
How to view created temporary tables in mysql
SQL
3 votes202 views5 answers
Mysql get last inserted id
SQL