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

11 votes132 views2 answers
MySQL DISTINCT
SQL
0 vote125 views1 answer
Oracle select invalid views
SQL
1 vote138 views1 answer
Psql import backup file for windows
SQL
3 votes140 views1 answer
Select sequence oracle
SQL
0 vote128 views1 answer
How to set all the min and sec data to zero in sql server
SQL
0 vote133 views1 answer
Java spring boot connect to sql server
SQL
4 votes86 views1 answer
And or sql order of operations
SQL
0 vote126 views2 answers
Update all columns in one update
SQL
1 vote122 views1 answer
Sql select all from one table and one column from another
SQL
34 votes165 views6 answers
Alter table add foreign key mysql
SQL