Oracle RPAD

RPAD is an Oracle string function that returns a right-padded string of ‘n’ characters, padded with a padding expression. The syntax of Oracle RPAD function is as follows: RPAD( Expression, n, ‘padding_value’) Here, Expression/Column Name –...

Oracle LPAD

LPAD is a function used in Oracle that returns a left padded string of ‘n’ characters, padded with a text value. The syntax of Oracle LPAD function is as follows: LPAD( Expression, n, ‘pad_value’) Here, Expression/Column Name – Expression could be a...

Oracle INSTR

INSTR is a special string function that returns the position of ‘text’ in a string, if the ‘text’ does not exist then it returns 0. Syntax: The syntax of the Oracle INSTR function is as follows: INSTR ( Expression, ‘text’ ) Or...

Oracle SUBSTR

SUBSTR is an Oracle String function used to extract characters from a string. Syntax Here’s the syntax of the Oracle SUBSTR function (). SUBSTR( Expression, x [, y]) Here, Expression = It is a string or a column name from which we want to extract characters. The...

Oracle LENGTH

LENGTH is an Oracle function that returns the length of string, i.e, total number of characters in a string. The syntax of LENGTH function is as follows: LENGTH ( expression); Here, expression = It could be a string or column name. The data type of this expression...

Oracle CONCAT

CONCAT is a string function which is used to combine two strings or expressions. Syntax The syntax of CONCAT () function is illustrated as follows: CONCAT ( expression1, expression2); Expression in this case is usually a string or column name which has string data...