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 votes128 views2 answers
Having clause
SQL
1 vote182 views1 answer
Postgresql append array
SQL
17 votes146 views2 answers
T_sql contains
SQL
1 vote149 views3 answers
How to pass password to mysql command line
SQL
0 vote140 views2 answers
How to find sql server agent jobs related to a database
SQL
1 vote129 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote159 views1 answer
SQL get max per id
SQL
13 votes139 views2 answers
Oracle select into and inner join
SQL
-1 vote98 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
15 votes144 views2 answers
Open postgress in terminal mac
SQL