The PLSQL ACOS function is used to return the arc cosine of a number. The ACOS function only one parameter which is a number and… Read More
Tag Archives: SQL-PL/SQL
The PLSQL TRANSLATE function is used for replacing a sequence of characters in a string with another set of characters. The PLSQL TRANSLATE function replaces… Read More
The PLSQL ASIN function is used to return the arc sine of a number. The ASIN function only one parameter which is a number and… Read More
The PLSQL VSIZE function is used for returning the number of bytes in the internal representation of an expression. The PLSQL accepts only one parameter… Read More
The PLSQL ABS function is used for returning the absolute value of a number. Absolute value is used for depicting the distance of a number… Read More
The PLSQL ATAN function is used to return the arc tangent of a number. The ATAN function accepts only one parameter which is a number… Read More
The PLSQL SUBSTR function is used for extracting a substring from a string. The SUBSTR function accepts three parameters which are input_string, start_position, length. SUBSTR… Read More
The PLSQL TRIM function is used for removing all specified characters either from the beginning or the end of a string. The TRIM function accepts… Read More
The PLSQL RTRIM function is used for removing all specified characters from the right-hand side of a string. The PLSQL RTRIM function accepts two parameters… Read More
The PLSQL NCHR function is used for returning the character based on the number code in the national character set or in other words it… Read More
The PLSQL RPAD function is used for padding the right-side of a string with a specific set of characters. a prerequisite for this is that… Read More
The PLSQL REPLACE function is used for replacing a sequence of characters in a string with another set of characters. The REPLACE function accepts three… Read More
The PLSQL SOUNDEX function is used for returning a phonetic representation of a string. The phonetic represents the way the string will sound. The PLSQL… Read More
The PLSQL LTRIM function is used for removing all specified characters from the left-hand side of a string. The PLSQL LTRIM function accepts two parameters… Read More
The PLSQL INSTRC function is used for returning the location of a substring in a string, Unicode complete characters. The PLSQL INSTRC function searches a… Read More
