Oracle SQL Functions

CHARTOROWID, CONVERT, HEXTORAW, RAWTOHEX, ROWIDTOCHAR, TO_CHAR, TO_DATE, TO_NUMBER.....
When one function is called inside the other, it is called a nested function....
There are two types of functions – Single row that operates row by row. Group function operates on multiple rows..