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 vote186 views1 answer
How to retrive the today date sql
SQL
0 vote193 views1 answer
Fix sqlite3 ruby on rails
SQL
3 votes201 views1 answer
Laravel database Using Named Bindings
SQL
0 vote187 views1 answer
Check if table exists oracle
SQL
0 vote196 views2 answers
Install phoenix
SQL
0 vote197 views1 answer
Flush user resource mysql
SQL
1 vote205 views2 answers
Create table if not exist
SQL
0 vote144 views1 answer
Microsoft sql server management studio clear cache
SQL
10 votes210 views2 answers
Tsql merge example
SQL
0 vote204 views1 answer
Sql change primary key to composite key
SQL