Description: oracle explain commonly used functions. SQL Record function of the single-1.ASCII back with a specified number of characters corresponding to the metric system SQL> select ascii (' ' A' ' ) A, ascii (' ' a' ' ) a, ascii ( ' ' 0' ' ) zero, ascii (' ' ' ' ) space from dual AA ZERO SPACE------------------------------------- 65 97 48 32 2.CHR give integer, return the corresponding character SQL> select chr (54740) zhao, chr (65) chr65 from dual ZH C-- Zhao A 3. CONCAT string connecting the two SQL> select concat (' ' 010-' ' ,' ' 88888888' ' )||' ' competing cadres to 23' ' phone from dual cadres competing phone---------------- 010-88888888 to 23
To Search:
File list (Check if you may need any files):
2008514211626.chm
Download