SQL: Structured Query Language - Oracle 10g Database Administration Concepts and Implementation Made Simple - page 28

Output:

Result
--------
9

Similarly we can use LENGTHB; for a single-byte database
character set, LENGTHB is equivalent to LENGTH. Let's
suppose a double-byte database character set.

SELECT LENGTHB ('SPIDERMAN') "Result"
FROM DUAL;

Output:

Result
--------
14

Date Functions:

Following functions fall under this category.

ADD_MONTH
S

MONTHS_BETWEE
N

LAST_DAY ROUND

SYSDATE TRUNC

Example:

SELECT ADD_MONTHS(hiredate,1)
FROM emp
WHERE ename = 'SMITH';