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 vote180 views1 answer
Oracle call a function in a insert statement
SQL
0 vote240 views1 answer
Python mysql executemany
SQL
0 vote213 views1 answer
Postgres regex word boundary
SQL
1 vote180 views1 answer
Sql bitwise operators
SQL
1 vote173 views1 answer
Set statistics on in ssms
SQL
0 vote193 views2 answers
Sql max count
SQL
5 votes201 views1 answer
Oracle list days between two dates
SQL
0 vote135 views1 answer
Bigquery information_schema schema all columns
SQL
7 votes186 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote188 views1 answer
Change magento database url usimg musql
SQL