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

11 votes149 views1 answer
Oracle view ddl
SQL
0 vote156 views1 answer
Get the previous column of a table in mysql
SQL
0 vote161 views1 answer
Java nosql sort
SQL
0 vote187 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote159 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
6 votes245 views1 answer
Sql insert values into table
SQL
0 vote160 views1 answer
Databricks install odbc driver connect to sql server
SQL
1 vote153 views2 answers
Postgres copy table from one schema to another
SQL
0 vote153 views1 answer
Mysql uuid
SQL
2 votes140 views2 answers
How to get capital letter first in sql
SQL