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

16 votes368 views1 answer
Mysql smallint range
SQL
0 vote361 views1 answer
Oracle free up space in tablespace
SQL
2 votes357 views1 answer
Oracle drop sequence if exists
SQL
0 vote381 views1 answer
Procedure excute monthly oracle
SQL
0 vote347 views2 answers
Sql server select where date
SQL
0 vote320 views1 answer
Create duplicate table in postgresql
SQL
0 vote364 views1 answer
Selecting all columns from table sql database
SQL
1 vote388 views1 answer
Mysql count all table rows
SQL
0 vote408 views1 answer
Postgres foreign key multiple columns
SQL
0 vote383 views1 answer
Change role postgres
SQL