Oracle SQL Functions Introduction

Overview

• Tutorial session for beginners on Oracle SQL functions
• Focus on introduction and types of functions

Types of Functions in Oracle SQL

• Input Functions: Two main categories:
  • Single Row Functions
  • Multi Row Functions

Single Row Functions

• Classified into five different built-in functions:
  1. Character Functions
     • Further classified into:
       • Case Manipulation
       • Character Manipulation
  2. Number Functions
  3. Date Functions
  4. Type Functions
  5. General Functions

Multi Row Functions

• Only one type:
  • Group or Aggregate Functions
  • Includes various infill functions

Upcoming Content

• Each function type will be explored briefly with examples in future videos.

Conclusion

• Thank you for participating.
• Subscribe for regular updates.