Oracle PLSQL

In this chapter we will explain the basics of payroll processing, such as what processing options are available, and the sequencing for processing employees’ payments. We will also define important terms and concepts, essential for day to day payroll administration. By the end of this chapter you will be able to run basic tasks such as creating a new payroll, a new assignment set,

This course is available as:

  • Instructor led training
  • e-Learning
  • Book
  • Any combination of the 3 options
  • End User
  • Implementer
  • Manager
  • Why use PL/SQL
  • Use of Data-Types
  • Anchored Data Type
  • PL/SQL Blocks
  • Declaring Variables with the %TYPE Attribute
  • Loops: Simple Loop
  • Printing Output
  • Functions and Procedures
  • Errors in a Procedure
  • Stored Procedures
  • Block Definition
  • Variables and Types
  • Control flow in PL/SQL
  • And many more…