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
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
0 vote161 views2 answers
Drop check constraint in ms sql
SQL
11 votes204 views2 answers
Mysql disable safe mode
SQL
4 votes220 views2 answers
Mysql alter table set column unique
SQL
28 votes134 views6 answers
Distinct sql
SQL
2 votes183 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote177 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote177 views1 answer
Alter rename command in mysql
SQL
2 votes184 views4 answers
2nd highest salary in mysql
SQL
0 vote172 views1 answer
How to add timestamp column in mysql
SQL