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 vote263 views1 answer
Sql server delete records with specific date
SQL
0 vote288 views1 answer
How to find table lock and row lock in mysql
SQL
0 vote276 views1 answer
How to combine rows in sql server procedure
SQL
1 vote302 views1 answer
Set id count mysql
SQL
13 votes273 views2 answers
Sql count distinct group by
SQL
2 votes281 views2 answers
Mysql find max value row
SQL
0 vote456 views1 answer
Multiple row join
SQL
0 vote273 views1 answer
Foreign key multiple columns
SQL
0 vote263 views1 answer
AddEntityFrameworkSqlite
SQL
6 votes263 views1 answer
Update left join mysql
SQL