Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Miscellaneous Functions

 

Miscellaneous functions

Name Function BFILENAMESimilar to C language. Returns a pointer, which is referred to as a locator in Oracle, to the associated physical LOB binary file where the file is stored.DECODEActs like nested IF...THEN...ELSE statement from a list of values. DUMPProvides a dump of values in a string VARCHAR2 to see the representation in many different formats.EMPTY_BLOBUsed to initialize a BLOB variable or column that will contain no data. EMPTY_CLOBUsed to initialize a CLOB variable or column that will contain no data.GREATESTTakes a list of values or expressions and returns the largest evaluated value. GREATEST_LBTakes a list of MLSLABELS and returns the greatest lower bound.LEASTTakes a list of values or expressions and returns the smallest evaluated value. LEAST_LBTakes a list of MLSLABELS and returns the least lower bound.NLS_CHARSET_IDReturns the NLS character set ID number associated with the NLS character set name. NLS_CHARSET_NAMEReturns the NLS character set name associated with the ID passed to the function.NVL Selects the first non-null value from a list of values or expressions. SQLCODEReturns an error code based upon the current error.SQLERRMReturns the error message associated with the Oracle error code. UIDReturns the USER ID assigned to the user in Oracle.USERReturns the name of the current user in a VARCHAR2 string. USERENVReturns information about your current working environment.VSIZEReturns the number of bytes in some value.