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 vote331 views1 answer
Como hacer una consulta en sql
SQL
0 vote336 views1 answer
SQLite3::SQLException: table "categories" already exists: CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL
SQL
1 vote297 views1 answer
Oracle current sequence value
SQL
1 vote314 views1 answer
Create table variable in sql stored procedure
SQL
23 votes342 views3 answers
Sql where contains part of string
SQL
3 votes303 views1 answer
Pl sql check if variable is empty
SQL
0 vote320 views1 answer
Postgresql delete multiple rows
SQL
0 vote364 views1 answer
Oracle sql developer closed connection
SQL
0 vote334 views1 answer
Sql last time database was accessed
SQL
0 vote332 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL