Tag: Oracle SQL

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)...

The Oracle/PLSQL ASCIISTR function converts a string of any character set to an ASCII string using the database character set. Syntax of the Oracle/PLSQL function ASCIISTR ASCIISTR( string_id...

The Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string. Syntax of the Oracle/PLSQL ASCII function ASCII( single_character_id )...

Oracle PL/SQL FunctionsFunction DescriptionBFILENAME The Oracle/PLSQL function returns the BFILENAME locator corresponding to the operating system's physical filename file...