What is String Function in SQL ?
SQL String function will be applied for each row and produces individual output for each row.
Other wise String function called as character function.
There are
| Sr.No. | Function & Description |
|---|---|
| 1 | UPPER convert the string into upper case. |
| 2 | LOWER convert the string into lower case. |
| 3 | INITCAP convert 1st character in each word into uppercase and other are lower in a string. |
| 4 | TRIM remove all specified characters from both sides of string. |
| 5 | RTRIM remove all specified characters from right end sides of string. |
| 6 | LTRIM remove all specified characters from left end sides of string. |
| 7 | RPAD allows you to pad the right side of column with any set of character. |
| 8 | LPAD allows you to pad the left side of column with any set of character. |
| 9 | TRANSLATE translate single character at a time |
| 10 | REPLACE replace multiple character at a time |
| 11 | SUBSTR to show specific character of a string |
| 12 | INSTR to show the position of character of a string |
| 13 | CONCAT used to combine two string. |
| 14 | ASCII return the decimal representation in database character set of the first character of string |
| 15 | CHR return the high level language character from ASCII value |
| 16 | SOUNDEX return the values whose pronunciation as some but spell differently |
| 17 | DECORD act as value by value substitution |
| 18 | GREATEST give the greatest string |
| 19 | LEAST give least string |
| 20 | COALESCE give the first non_null string |
| 21 | LENGTH give length of string |
| 22 | CONCATENATION |
| 23 | || |
1.UPPER
This will convert the string into uppercase.
Syntax: upper (string)
Ex:
SQL> select upper(‘computer’) from dual;
output COMPUTER
Pages: 1 2