one, the character function: lowercase functions: lower (); usage: For example, all the names of a table are lowercase: Select Lower (t.ename) from Scott.emp t uppercase Function: Upper (); to use: For example, capitalize all the names of a table: Select Upper (T.ename) from Scott.emp t length function: Long (); to use: For example, remove all names of a table as 5 characters in length: Select T.ename from scott.emp t where length (t.ename) = 5 Note: Length refers to the length of the string such as "China" is 2 "AB" also 2 Intercept string: substr (char,m,n) usage: For example, display the first three characters of all employees Select substr (t.ename, 1, 3) from Scott.emp t Comprehensive Application: display all employee names in uppercase letters 1.select Upper (substr (T.ename, 1, 1)) | | Lower (substr (t.ename, 2, Length (t.ename)-1)) from Scott.emp t 2. Select Initcap (ename) from Scott.emp;
Oracle character function lower () upper () Length () substr ()