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 vote165 views1 answer
2020 new year
SQL
1 vote189 views2 answers
Oracle leftmost characters
SQL
1 vote190 views2 answers
How to combine 2 tables in MySQL
SQL
1 vote157 views1 answer
Firebase bigquery cloud message
SQL
0 vote164 views2 answers
Create fulltext index mysql
SQL
0 vote189 views1 answer
Sql tabelle erstellen
SQL
-1 vote171 views1 answer
Capitole toulouse
SQL
0 vote188 views1 answer
How to find lowest in sql
SQL
0 vote178 views1 answer
Update and keep original value sql
SQL
1 vote155 views1 answer
Adding a default constraint to an existing column in sql
SQL