ORACLE TO CHAR

The Oracle TO_CHAR function is used to convert a DATE value to string or text value. The TO_CHAR function is very useful for formatting the dates in a table to a specified date format. Syntax The syntax of TO_CHAR function is as follows: TO_CHAR( date, format ) Here,...

ORACLE TO_DATE

The Oracle TO_DATE function is used for converting text strings with VARCHAR2 data type to DATE data type. Syntax The syntax of Oracle TO_DATE function is as follows: TO_DATE ( text, format ) Here, Text – It is the date in text literal or character string that...

Oracle MOD

MOD is an Oracle function which returns the remainder after dividing one value with other. Syntax The syntax of Oracle function is as follows: MOD( x, y) Here, x – The value that MOD function will divide y – The value that is used for dividing MOD function...

Oracle ROUND

ROUND is a special function used in Oracle to round off the numeric digits after decimal up to n decimal places. If we specify n as 0, then the ROUND function rounds off the value before the decimal point. The ROUND functions works the same way as rounding off works...

Oracle TRUNC

TRUNC is an Oracle function used for truncating the value up to n decimal places after the decimal point. If we specify n as 0 then truncation happens only up to the digit before the decimal point. Unlike the ROUND function, TRUNC function simply truncates the value...

Oracle REPLACE

REPLACE is a string function used in Oracle to find a ‘text value1’ in expression or column and replace it with ‘text value2’. Syntax The Syntax of REPLACE function is as follows: REPLACE( Expression, text_value1 [,text_value2]) Here,...