Oracle PL/SQL Functions
Oracle PL/SQL offers a wide range of built-in functions that can be used to perform various operations on data stored in the database. Some examples of Oracle PL/SQL functions include:
LENGTH returns the number of characters in a string.
SUBSTR returns a specified portion of a string.
INSTR returns the position of a specified substring within a string.
TO_DATE converts a string to a date.
TO_CHAR converts a date or number to a string.
ROUND rounds a number to a specified decimal place.
TRUNC truncates a number to a specified decimal place.
MOD returns the remainder of a division operation.
NVL returns the first non-null expression in a list of expressions.
COUNT returns the number of rows returned by a query.
SUM returns the sum of a column’s values in a query.
AVG returns the average of a column’s values in a query.
MAX returns the maximum value of a column in a query.
MIN returns the minimum value of a column in a query.
UPPER converts a string to uppercase.
LOWER converts a string to lowercase.
These functions can be used in SQL statements and PL/SQL blocks to manipulate data and perform calculations.