Shulou(Shulou.com)06/01 Report--

1Perfect INITCAP (C1)

This function capitalizes the first letter of each word in C1 and returns the other letters in lowercase.

Select initcap (ename) from emp

2, LENGTH (C1)

This function returns the length of C1.

Select ename from emp where length (ename) = 4

3, REPLACE (C1, c2, c3)

This function returns after replacing c2, which appears in C1, with c3.

Select replace (ename,'A','X') from emp

4, SUBSTR (C1 and iMagol j)

This function indicates that a substring of length j is returned from bit I of C1.

Select substr (ename,0,3) from emp

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.