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 vote152 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
0 vote147 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote155 views1 answer
Reset keys in sql
SQL
0 vote152 views1 answer
Change magento database url usimg musql
SQL
32 votes141 views6 answers
Insert select
SQL
0 vote145 views1 answer
Disableforiegn key check
SQL
0 vote137 views1 answer
Postgres week number
SQL
0 vote124 views1 answer
Create bakupd database sqlserver
SQL
0 vote144 views1 answer
Version and edition of SQL Server Database Engine
SQL
5 votes141 views1 answer
Oracle sysdate
SQL