by Dexter | Dec 5, 2020 | Oracle SQL
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,...
by Dexter | Dec 5, 2020 | Oracle SQL
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...
by Dexter | Dec 5, 2020 | Oracle SQL
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...
by Dexter | Dec 5, 2020 | Oracle SQL
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...
by Dexter | Dec 5, 2020 | Oracle SQL
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...
by Dexter | Dec 5, 2020 | Oracle SQL
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,...