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 vote226 views1 answer
Sql query to return field name of a table
SQL
-1 vote258 views1 answer
Difference berween database and data base management system
SQL
0 vote224 views1 answer
Connecting to my cloud sql server with c#
SQL
2 votes230 views1 answer
How to delete all duplicate items in mysql
SQL
1 vote237 views1 answer
How to get the date diff on once field in sql server
SQL
13 votes220 views1 answer
Sql join 3 tables on id
SQL
0 vote229 views3 answers
Classement rang mysql 7
SQL
2 votes199 views2 answers
Select multiple tables mysql
SQL
0 vote231 views2 answers
Homebrew nysql launch
SQL
0 vote215 views1 answer
H2 auto increment and unique
SQL