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 vote194 views3 answers
SQL to LINQ converter
SQL
4 votes207 views4 answers
Pl sql output
SQL
0 vote195 views1 answer
We are intrested to work with your organization
SQL
19 votes208 views6 answers
Sql create table
SQL
0 vote217 views1 answer
Drop specific row postgresql
SQL
0 vote198 views1 answer
Sql pivot without aggregate
SQL
0 vote295 views1 answer
Show mysql account privilleges
SQL
8 votes223 views1 answer
Mysql restore database
SQL
0 vote193 views1 answer
Oracle shrink table
SQL
0 vote194 views1 answer
Sql reverse order of results
SQL