Tag: PLSQL

The Oracle/PLSQL TO_CHAR function converts a number or date into a string. Syntax of the Oracle/PLSQL TO_CHAR function TO_CHAR( value_id, [ format_mask_id ], [ nls_language_id ] ) Parameters...

The Oracle/PLSQL SUBSTR function allows extracting a substring from a string. Syntax of the Oracle/PLSQL SUBSTR function SUBSTR( string_id, start_position_id, [ length_id ] )  Parameters and...

` Parameters and function argumentsstring1_id - string whose phonetic value will be returned.The return value of the SOUNDEX function will always start with the first letter...

The Oracle/PLSQL RTRIM function removes all specified characters from the right side of the string. Syntax of the Oracle/PLSQL RTRIM function RTRIM( string1_id, [ trim_string_id ] ) Parameters...

The Oracle/PLSQL RPAD function supplements a certain character set from the right side of the string (at non-zero string1). Syntax of the Oracle/PLSQL RPAD function RPAD( string1_id,...

The Oracle/PLSQL REPLACE function replaces a sequence of characters in a string with another character set. Oracle/PLSQL REPLACE function syntax REPLACE( string1_id, string_to_replace_id, [...

The Oracle/PLSQL REGEXP_SUBSTR function is an extension of function SUBSTR. This function, represented in Oracle 10g, allows you to extract substring from a string using regular expression...

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 [,...