sql codes

Oracle COS Function

Oracle VARIANCE Function

SQL To get the Server Timezone.

Sending Mail in MS SQL

Oracle CORR Function

Oracle DBTIMEZONE Function

Oracle BFILENAME Function

Oracle SESSIONTIMEZONE Function

Oracle BIN_TO_NUM Function

Oracle CUME_DIST Function

Oracle CHARTOROWID Function

Oracle ASIN, ACOS, ATAN, ATAN2, and COSH Functions

Oracle GROUP_ID Function

Oracle EMPTY_CLOB Function

Oracle EMPTY_BLOB Function

Oracle NEW_TIME Function

Oracle TO_SINGLE_BYTE Function

Oracle NCHR Function

Oracle NANVL Function

Oracle DECOMPOSE Function

Oracle COMPOSE Function

Oracle TO_LOB Function

Oracle LOCALTIMESTAMP Function

Oracle ASCIISTR Function

Oracle TO_NCLOB Function

Oracle TO_CLOB Function

Oracle STDDEV Function

Oracle FROM_TZ Function

Oracle TZ_OFFSET Function

Oracle LOWER Function

Oracle INITCAP Function

Oracle RAWTOHEX Function

Oracle TO_YMINTERVAL Function

Oracle TO_DSINTERVAL Function

Oracle NUMTOYMINTERVAL Function

Oracle NUMTODSINTERVAL Function

Oracle LAG Function

Oracle SQLCODE Function

Oracle LEAD Function

Oracle SUM Function

Oracle EXTRACT Function

Oracle DUMP Function

Oracle MAX function

Oracle COUNT Function

Object Dependencies TSQL

Oracle CONVERT Function

Oracle TRANSLATE Function

Oracle HEXTORAW Function

Oracle SOUNDEX Function

Oracle CURRENT_DATE Function

Oracle USERENV Function

Oracle NEXT_DAY Function

Oracle CURRENT_TIMESTAMP Function

Oracle BITAND Function with Examples

Oracle AVG Function

Oracle ASCII Function

Oracle SIGN Function

Oracle RANK Function

Oracle POWER Function

Oracle MIN Function

Oracle USER Function

Oracle ABS Function

Oracle DENSE_RANK Function

Oracle SYSTIMESTAMP Function

Oracle SQLERRM Function

Oracle SYS_CONTEXT Function

Oracle LOG Function

Oracle LAST_DAY Function

Oracle FLOOR Function

Oracle MOD Function

Oracle NULLIF Function

Oracle REMAINDER Function

Oracle TO_TIMESTAMP_TZ Function

Oracle ADD_MONTHS Function

Oracle COALESCE Function

Oracle UPPER Function

Oracle CAST Function

Oracle LPAD Function

Oracle TRUNC Function

Oracle MONTHS_BETWEEN Function

Oracle TRIM Function

Oracle DECODE Function

Oracle ROUND Function

Oracle SUBSTR Function

Oracle TO_TIMESTAMP Function

Oracle NVL Function

Oracle CHR Function

Oracle CEIL Function

Oracle EXP Function

Oracle TO_NUMBER Function

Oracle RPAD Function

Oracle LENGTH Function

Oracle LTRIM Function

Oracle INSTR Function

Oracle RTRIM Function

Oracle CASE Expression

Oracle REPLACE Function

Oracle GREATEST Function

Oracle LEAST Function