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 vote353 views1 answer
Regular expression in sql server
SQL
0 vote329 views1 answer
Joins vs includes
SQL
1 vote311 views3 answers
Remove unique key from a table
SQL
0 vote316 views1 answer
Remove from table where
SQL
0 vote359 views1 answer
Sqlalchemy empty table
SQL
0 vote331 views1 answer
Sql delete where x or y or z
SQL
1 vote339 views1 answer
Sql alchemy with azuresql server
SQL
2 votes344 views1 answer
Mysql ALTER TABLE ADD COLUMN BOOLEAN AFTER DEFAULT "1";
SQL
-1 vote347 views1 answer
Module operator in oracle sql
SQL
0 vote348 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL