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 vote162 views1 answer
Insert value list does not match column list: 1136 Column count doesn't match value count at row 2"
SQL
0 vote184 views1 answer
Mysql not defined
SQL
5 votes202 views3 answers
Select tables from mysql database
SQL
1 vote184 views1 answer
Mysql order by desc null last
SQL
10 votes201 views4 answers
Fetch first 5 characters of the string in sql
SQL
1 vote179 views1 answer
Decalre temp table sql
SQL
3 votes282 views4 answers
Sql interview questions
SQL
1 vote206 views2 answers
How to add amount between date in sql
SQL
0 vote148 views1 answer
Jooq finding lastest value in table
SQL
0 vote187 views2 answers
Get item by composite primary key mysql
SQL