Subscribe for more PL SQL tutorials
String 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 return the appended string.
Converts the initial letter of each word in x to uppercase and returns that string.
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.
Simply Easy Learning Page 59
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.
LPAD(x, width [, pad_string]) ;
Pads x with spaces to left, to bring the total length of the string up to width characters.
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
Same as the INITCAP function except that it can use a different sort method as specified
Same as the LOWER function except that it can use a different sort method as specified
Same as the UPPER function except that it can use a different sort method as specified
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.
NVL2(x, value1, value2);
Returns value1 if x is not null; if x is null, value2 is returned.
REPLACE(x, search_string, replace_string);
Searches x for search_string and replaces it with replace_string.
RPAD(x, width [, pad_string]);
Pads x to the right.
RTRIM(x [, trim_string]);
Trims x from the right.
Returns a string containing the phonetic representation of x.
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 the parameters are expressed in bytes instead of characters
for the single-byte character systems.
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.
Looking for someone like-minded? Chances are you’ve already got one thing in common.
15,000 New members.
Soulmates sees over 15,000 new faces every month.
#1 Customer service.
Feel safe and secure, with help from our award-winning customer service team.
Recently joined Soulmates.
Meet some of our latest members.
Online Dating Success Stories.
Intrepid explorers who’ve found the person of their dreams.
Kristian & Zoe.
"We met through Soulmates four years ago. Although were both based in London, the chances of us meeting by other means were slim. We just got married! Zoe is the most wonderful woman Ive ever met, and I know we are going to have an extremely happy life together."
Laura & Phil.
"Phil and I got married just over a year after we met on my first ever internet date through Guardian Soulmates. Weve been recommending the site to friends ever since. Thank you!" (Photography credit to Michael OSullivan)
Robin & Alec.
"I just wanted to let you know that you have another success story! My boyfriend, who I met via your site about two years ago, just proposed and we are getting married next year. THANK YOU!"
Alex & Rosie.
"Rosie and I met through Soulmates and were married in October, just 17 months later. Were wonderfully happy together!"
How does it work?
Find your Soulmate in three easy steps.
Register your free account today.