The PLSQL INSTR4 function is used for returning the location of a substring in a string using UCS4 code points. UCS-4 codepoints is a character… Read More
Tag Archives: SQL-PL/SQL
The PLSQL INSTRB function is used for returning the location of a substring in a string, using bytes instead of characters. The PLSQL INSTRB function… Read More
The PLSQL LOWER function is used for converting all letters in the specified string to lowercase. If there are characters in the string that are… Read More
The PLSQL INSTR2 function is used for returning the location of a substring in a string using UCS2 code points. UCS-2 codepoints is a character… Read More
The PLSQL LPAD function is used for padding the left-side of a string with a specific set of characters. a prerequisite for this is that… Read More
The PLSQL LENGTH4 function is used for returning the length of the specified string, using UCS4 code points. UCS-4 codepoints is a character encoding which allows… Read More
The PLSQL LENGTHB function is used for returning the length of the specified string using bytes instead of characters. The char accepted by the LENGTHB… Read More
The PLSQL LENGTH function is used for returning the length of the specified string, in other words, it returns the length of char. The char… Read More
The PLSQL LENGTH2 function is used for returning the length of the specified string, in other words, it returns the length of char. UCS-2 codepoints… Read More
The PLSQL LENGTHC function is used for returning the length of the specified string using UNICODE complete characters. The char accepted by the LENGTHC function… Read More
The DECOMPOSE Function in PLSQL is used for accepting a string and returning its Unicode string. The DECOMPOSE Function is generally the opposite of the… Read More
The PLSQL INSTR function is used for returning the location of a substring in a string. The PLSQL INSTR function searches a string for a… Read More
The PLSQL DUMP function is used to return a varchar2 value that contains the datatype code, the length in bytes, and the internal representation of… Read More
The INITCAP function in PLSQl is used for setting the first character in each word to uppercase and the rest to lowercase. Words are delimited… Read More
The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters or… Read More
