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

1 vote264 views1 answer
Does insert into overwrite sql
SQL
4 votes277 views1 answer
Oracle error line
SQL
20 votes261 views4 answers
Sqlite create table if not exists
SQL
1 vote259 views1 answer
Sql server get users
SQL
0 vote268 views1 answer
Jenkins SQLCMD run
SQL
0 vote301 views1 answer
Select new table sql
SQL
0 vote264 views1 answer
How to create a table in sql stack overflow
SQL
0 vote217 views1 answer
Mysql offset from bottom
SQL
0 vote257 views1 answer
Order by with where clause in mysql
SQL
10 votes234 views2 answers
Sql where clause multiple values
SQL