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 vote363 views1 answer
Drop view sql
SQL
0 vote318 views1 answer
Qt qsql check if table exist
SQL
2 votes309 views1 answer
How to make insert script from table in SQL server
SQL
0 vote314 views1 answer
Populate db from command line postgres
SQL
1 vote299 views1 answer
Add constraint sql
SQL
0 vote351 views2 answers
Mysql insert into multiple tables
SQL
0 vote313 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
1 vote329 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote337 views1 answer
Alter table add check constraint oracle
SQL
1 vote296 views1 answer
Sql select table header
SQL