By Manish Sharma

SQL functions are divided into two categories

  1. Single Row Functions
  2. Multiple row function which is also known as aggregate functions.

Single Row Functions.

  • Single-row functions operate on one row at a time and return one row of output for each input row.
  • Single row functions are capable of manipulating data items and modifying the data types.
  • Single row functions return one result per row and act on each row that is returned.
  • Single row functions can accept one or more arguments and return one value.
  • These arguments can be a column or an expression.

With oracle we have 5 types of Single Row Functions

  1. Character Functions
  2. Number Functions
  3. General Functions
  4. Conversion Functions and
  5. Date Functions.

Character Functions are further divided into two categories.

  1. Case- manipulation functions
  2. Character Manipulation functions.

We have 3 case manipulation functions.

  1. Lower()
  2. upper () and
  3. initcap ()

and 7 character manipulation functions Sql functions

  1. concat(),
  2. substr(),
  3. length(),
  4. instr(),
  5. lpad() | rpad(),
  6. trim ()and
  7. replace().

  • Manish Sharma Oracle Rebellion Rider
  • Manish Sharma Oracle certified SQL expert
  • Manish Sharma oracle certified associate
  • Manish Sharma oracle certified professional
  • View Manish Sharma's profile on LinkedIn
  •          View Manish Sharma's profile on LinkedIn