Oracle 11g SQL Fundamentals 01--String manipulation function

on the left of 1200 on the right of 1200

concat (' Hello ', ' world ')     stitching	HelloWorld
substr (' HelloWorld ', 1,5)   intercept	Hello
Length (' HelloWorld ')         string length	ten
InStr (' HelloWorld ', ' W ')   W characters first occurrence	6
Lpad (1200,6, ' * ')   If 1200 complements 6 bits, fill ' * '	**1200
rpad (1200,6, ' * ')   If 1200 complements 6 bits, fill ' * '	1200**
replace (' JACK and Jue ', ' j ', ' BL ') replaces ' J ' in the string with ' bl '	BLACK and BLUE
Trim (' h ' from ' Hello Word ') removes the ' H ' character in the string	Ello Word

Oracle 11g SQL Fundamentals 01--String manipulation function