INSTRC Returns the position of a String within a String , expressed in Unicode complete characters INSTRReturns the position of a String within a. If a string function is given a binary string as an argument, the resulting string is also a binary string. A number converted to a string is treated as a binary string. A text expression that is the base string from which the substring is created.
This affects only comparisons. The position at which the first character of the returned string begins. When position is (zero), then it is treated as 1. The starting position for extraction. The first position in the string is always 1. It is the number of characters to extract. If this parameter is omitte the SUBSTR function will return the entire string.
The SUBSTR functions return a portion of char, beginning at character position, substring_length characters long. If position is then it is treated as 1. SQL functions are built into Oracle Database and are available for use in various appropriate SQL statements. Additional undocumented string related functions can be found on the Undocumented Oracle. The Oracle CONVERT() function accepts three arguments: 1) string _expression. The different types of functions in Oracle are: Oracle String Functions Oracle Numeric Functions Oracle Date Functions More details about these functions are gi.