Oracle Programming Workshop

An Oracle Programming Workshop as planned for Community and On the Job Training Students of Information Technology has been conducted on 17th of March 2022 from 11.00 AM – 1.00 PM. The objective of the programme is to give an insight about the Oracle Application Express Environment and its Tools. 

The speaker discussed about the Oracle Corporation’s procedural programming language for relational databases. To describe PL/SQL, and learn its characteristics, identify the differences between PL/SQL and SQL Identifying limitations of SQL and how PL/SQL addresses those limitations will help us to understand why PL/SQL is needed. Furthermore, how PL/SQL integrates control statements and conditional statements with SQL for better control of SQL statements and their execution has also been delivered.

The delivery and objective of this workshop includes the integration of PL/SQL in Oracle tools, such as Oracle Forms Developer, Oracle Report Builder, and Application Express.

During the presentation, hands on practical session for writing the effective Procedural Language code and executing it as anonymous block without database server and using database server has also been demonstrated.

Finally, the speaker demonstrated about the Implicit Cursors, Explicit Cursors. Usage of Loops, If –Else, Fetch, User Defined , Predefined Exception Handling..etc.