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 vote105 views1 answer
Mysql cdn link
SQL
0 vote111 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote110 views1 answer
Mysqldump ignore table
SQL
0 vote130 views1 answer
Sql output select
SQL
0 vote126 views1 answer
Hoq to import database source
SQL
0 vote116 views1 answer
Split string by comma in sql server
SQL
0 vote126 views1 answer
Getting next sequence value jpa postgress
SQL
0 vote129 views1 answer
Oracle last connexion
SQL
3 votes122 views1 answer
Postgres select max value
SQL
0 vote127 views1 answer
C# execute transact sql
SQL