ORACLE SQL single-line function (iii) "Weber products must be a boutique"

16.L: Represents the local currency symbol, which is related to the region. This time we want to show the symbol of RMB: ￥

$ VI. Bash_profile---write the following: Export Nls_lang='Simplified Chinese'_china. Al32utf8---Change to Simplified Chinese + region +character set source. Bash_profile---make environment variables effective [[email protected]~]$ Sqlplus scott/Tiger SQL*plus:release10.2.0.5.0-Production on Friday August the  -: -: A  theCopyright (c)1982, ., Oracle.  All rights Reserved. Connected to:oracle Database 10g Enterprise Edition Release10.2.0.5.0-Productionwith The partitioning, OLAP, Data Mining and Real application testing options SQL>---If you are using X-shell or putty to connect to Linux remotely, you need to change your client's character set back

17.to_number: Converting a string to a number

Convert decimal to 16 binary: (TO_CHAR)

Select to_char,'xxx' from dual; To_char (,'------------   a

Convert 16 binary to decimal: (To_number)

Select to_number ('a','xxx' from dual; To_number ('A','XXX')---------- ----------          Ten

18. Two-bit representation of the date: RR and yy

Sql>Select* fromEmpwhereHiredate=to_date ('17-12-80','DD-MM-RR'); EMPNO ename JOB MGR hiredate SAL COMM DEPTNO----- ------ --------- ----- ------------------- ----- ---------- ------7369SMITH Clerk7902 1980- A- - xx:xx:xx    -                 -two-bit representation of the date: RR and yy yy: Always consistent with the current century RR: Gets the year closest to the current year