|S.No||Function & Purpose|
Returns the ASCII value of the character x.
Returns the character with the ASCII value of x.
Concatenates the strings x and y and returns the appended string.
Converts the initial letter of each word in x to uppercase and returns that string.
|5||INSTR(x, find_string [, start] [, occurrence]);
Searches for find_string in x and returns the position at which it occurs.
Returns the location of a string within another string, but returns the value in bytes.
Returns the number of characters in x.
Returns the length of a character string in bytes for single byte character set.
Converts the letters in x to lowercase and returns that string.
|10||LPAD(x, width [, pad_string]) ;
Pads x with spaces to the left, to bring the total length of the string up to width characters.
|11||LTRIM(x [, trim_string]);
Trims characters from the left of x.
Returns value if x matches the NaN special value (not a number), otherwise x is returned.
Same as the INITCAP function except that it can use a different sort method as specified by NLSSORT.
Same as the LOWER function except that it can use a different sort method as specified by NLSSORT.
Same as the UPPER function except that it can use a different sort method as specified by NLSSORT.
Changes the method of sorting the characters. Must be specified before any NLS function; otherwise, the default sort will be used.
Returns value if x is null; otherwise, x is returned.
|18||NVL2(x, value1, value2);
Returns value1 if x is not null; if x is null, value2 is returned.
|19||REPLACE(x, search_string, replace_string);
Searches x for search_string and replaces it with replace_string.
|20||RPAD(x, width [, pad_string]);
Pads x to the right.
|21||RTRIM(x [, trim_string]);
Trims x from the right.
Returns a string containing the phonetic representation of x.
|23||SUBSTR(x, start [, length]);
Returns a substring of x that begins at the position specified by start. An optional length for the substring may be supplied.
Same as SUBSTR except that the parameters are expressed in bytes instead of characters for the single-byte character systems.
|25||TRIM([trim_char FROM) x);
Trims characters from the left and right of x.
Converts the letters in x to uppercase and returns that string.
krishna kumar on How to create virtual host in… vipul on To get current location using… How to create virtua… on How to create virtual host in…
- June 2018
- May 2018
- April 2018
- March 2018
- January 2018
- December 2017
- October 2017
- July 2017
- June 2017
- May 2017
- April 2017
- March 2017
- February 2017
- January 2017
- December 2016
- October 2016
- September 2016
- July 2016
- June 2016
- May 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- October 2015
- July 2015
- March 2014
- September 2013
- June 2013