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 vote321 views1 answer
Stop mysql server mac
SQL
0 vote324 views1 answer
Sum values by month mariadb
SQL
16 votes332 views3 answers
Delete row psql
SQL
0 vote390 views1 answer
Mysql get nth highest
SQL
0 vote321 views1 answer
Sql server remove 0 from left
SQL
24 votes309 views5 answers
Sql reset auto increment
SQL
0 vote306 views1 answer
Suse start MySQL
SQL
1 vote331 views1 answer
How to between in sql
SQL
0 vote522 views2 answers
Create new table from existing table with data in sql server
SQL
1 vote325 views1 answer
Full sql mode
SQL