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 vote330 views1 answer
Mysql into outfile with headers
SQL
0 vote368 views1 answer
Modifier une valeur sql
SQL
-1 vote346 views2 answers
How to select the lowest values from table per client sql
SQL
6 votes327 views5 answers
Mysqli_real_connect(): (HY000/1698): Access denied for user 'root'@'localhost'
SQL
0 vote354 views3 answers
Magento 2 order delete from db
SQL
-1 vote361 views1 answer
Phinehas Psalm 106
SQL
0 vote319 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote333 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
2 votes366 views3 answers
Row number mssql
SQL
14 votes353 views4 answers
Remove record from table sql
SQL