Tag: Oracle

The Oracle/PLSQL REGEXP_REPLACE function is an extension of the function REPLACE. This function, introduced in Oracle 10g, allows you to replace a sequence of characters in a string with a...

Oracle REGEXP_LIKE function allows regular expressions in the WHERE sentence in SELECT, INSERT, UPDATE or DELETE queries. Syntax for REGEXP_LIKE in Oracle/PLSQL REGEXP_LIKE ( expression_id,...

The Oracle/PLSQL LTRIM function removes all specified characters from the left side of the string. Syntax of the Oracle/PLSQL LTRIM function LTRIM( string1_id, [ trim_string _id ) ) Parameters...

The Oracle/PLSQL LPAD function adds a certain set of characters from the left side of the string (at non-zero string1). Syntax of Oracle/PLSQL LPAD function LPAD( string1_id, padded_length_id,...

The Oracle/PLSQL LOWER function converts all characters in a specified string into lower case. If there are characters in the string that are not letters, they do not affect this...

The Oracle/PLSQL LENGTH function returns the length of the specified string. Syntax of the Oracle/PLSQL LENGTH function LENGTH( string1_id ) Parameters and function argumentsstring1_id -...

The Oracle/PLSQL INSTRB function returns substring occurrence in a string, bytes instead of characters. Syntax of the Oracle/PLSQL INSTRB function INSTRB( string_id, substring_id [,...

The Oracle/PLSQL INSTR4 function returns substring occurrence in a string using UCS4 code points. Function Oracle/PLSQL INSTR4 syntax INSTR4( string_id, substring_id [, start_position_id [,...

The Oracle/PLSQL INSTR2 function returns substring occurrence in a string using UCS2 code points. Function Oracle/PLSQL INSTR2 syntax INSTR2( string_id, substring_id [, start_position_id [,...

The Oracle/PLSQL INSTR function returns the n-th occurrence of a substring in a string. Oracle/PLSQL INSTR function syntax INSTR( string1, substring1 [, start_position_id [, nth_appearance_id ]...

The Oracle/PLSQL INITCAP function sets the first character of each word in upper case, and the rest in lower case. Syntax of the Oracle/PLSQL INITCAP function INITCAP( string1_id ) Parameters...

The Oracle/PLSQL DUMP function returns a value of varchar2, which includes data type code, length in bytes, and the internal representation of the expression. Oracle/PLSQL DUMP function...

Oracle/PLSQL concatenation operator || allows to combine two or more lines together. Syntax for the Oracle/PLSQL statement || string1_id || string2_id || string_n_id Operator parameters and...

The Oracle/PLSQL CONCAT function allows two lines to be connected together. Syntax of the Oracle/PLSQL CONCAT function CONCAT( string1_id, string2_id ) Parameters and function arguments...

The Oracle/PLSQL COMPOSE function returns the Unicode string. Oracle PLSQL COMPOSE function syntax COMPOSE( string_id ) Parameters and function argumentsstring_id - is an input value...

The Oracle/PLSQL CHR function is the opposite of the ASCII function. CHR returns a character that is based on numeric code. Syntax of the Oracle/PLSQL CHR function CHR (number_code_id)...