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 vote199 views1 answer
Enable mysql slow query log
SQL
1 vote235 views1 answer
Multiple count in sql
SQL
2 votes240 views1 answer
Drop all database tables oracle sql developer
SQL
1 vote225 views1 answer
Oracle convert run duration to number
SQL
1 vote237 views1 answer
Postgres check for foreign key
SQL
11 votes221 views2 answers
Having keyword sql
SQL
1 vote232 views2 answers
Datetrunc hour snowflake
SQL
2 votes251 views1 answer
Merge firstname and lastname in sql oracle
SQL
11 votes243 views2 answers
Turn off safe mode mysql
SQL
0 vote234 views2 answers
Postgres another version
SQL