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 vote118 views1 answer
Get who is hired in specific month in sql
SQL
0 vote124 views1 answer
Sql server create constraint
SQL
6 votes107 views1 answer
Allsource oracle
SQL
0 vote115 views2 answers
Mysql password error create datbase
SQL
0 vote130 views2 answers
Mysql dump structure only
SQL
10 votes121 views4 answers
Fetch first 5 characters of the string in sql
SQL
3 votes129 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote140 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote116 views1 answer
Mysql group by derived column
SQL
0 vote115 views1 answer
Microsoft word insert sql code
SQL