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

13 votes141 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote134 views1 answer
Save single sql query result boolean spring boot
SQL
0 vote178 views1 answer
Sql create and grant user access to database
SQL
6 votes164 views3 answers
Date_trunc postgres
SQL
0 vote175 views1 answer
Edit shchima table in sql
SQL
3 votes148 views2 answers
How to start mysql in terminal
SQL
1 vote167 views1 answer
Nullif postgresql
SQL
-2 votes159 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote172 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote150 views1 answer
Dns slave zone convert
SQL