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 vote284 views1 answer
Oracle activate job
SQL
1 vote285 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
13 votes301 views2 answers
Sql join 3 tables
SQL
3 votes308 views1 answer
Sql case update
SQL
0 vote364 views1 answer
How to subquey to do not load in live database in
SQL
0 vote305 views1 answer
Drop database using terminal postgres
SQL
0 vote318 views1 answer
Mysql 3 months ago
SQL
0 vote272 views1 answer
Mysql update sum same table
SQL
0 vote305 views1 answer
Limit in access query
SQL
0 vote294 views3 answers
Query string not ending with with vowels
SQL