//
archives

PL/SQL

This category contains 2 posts

PL/SQL New Feature : CONTINUE statement

CONTINUE statement is finally comes with Oracle 11g. It comes in two forms: CONTINUE Continue statement terminates the current iteration of the loop and passes the control to the next iteration of the loop. NOTE: CONTINUE statement condition evaluates with the help of IF statement. CONTINUE WHEN Same as CONTINUE statement. But the condition in … Continue reading

PL/SQL Package : UTL_FILE

Introduced in Oracle 7.3, UTL_FILE PL/SQL package provides a functionality of reading and writing text file into operating system files. That means you can load external data from other source to database or can generate report from your PL/SQL code and write to text file on operating system. UTL_FILE package provides access to text file … Continue reading