Answers for "output table plsql"

SQL

0

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;
        /

Posted by: Guest on June-24-2021

Source

Code answers related to "output table plsql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#