Home >> FAQs/Tutorials >> Oracle Tutorials

Oracle Tutorials - Introduction to PL/SQL

By: FYIcenter.com

A collection of 17 FAQs to introduce PL/SQL language for DBA and developers. This FAQ can also be used as learning tutorials on creating procedures, executing procedures, using local variables, controlling execution flows, passing parameters and defining nested procedures. Topics included in this FAQ are:

  1. What Is PL/SQL?
  2. What Are the Types PL/SQL Code Blocks?
  3. How To Define an Anonymous Block?
  4. How Many Anonymous Blocks Can Be Defined?
  5. How To Run the Anonymous Block Again?
  6. What Is a Stored Program Unit?
  7. How To Create a Stored Program Unit?
  8. How To Execute a Stored Program Unit?
  9. How Many Data Types Are Supported?
  10. What Are the Execution Flow Control Statements?
  11. How To Use SQL Statements in PL/SQL?
  12. How To Process Query Result in PL/SQL?
  13. How To Create an Array in PL/SQL?
  14. How To Manage Transaction Isolation Level?
  15. How To Pass Parameters to Procedures?
  16. How To Define a Procedure inside Another Procedure?
  17. What Do You Think about PL/SQL?

Sample scripts used in this FAQ assumes that you are connected to the server with the HR user account on the default database instance XE. See other FAQ collections on how to connect to the server.

(Continued on next topic...)

Oracle Tutorials:

More...


Other Tutorials/FAQs:

More...


Related Resources:

More...


Selected Jobs:

More...