x3553457的博客

select sys_context('USERENV','AUTHENTICATION_TYPE') from dual;--用户的认证类型select sys_context('USERENV','AUTHENTICATION_DATA') from dual;--未知select sys_context('USERENV','BG_JOB_ID') from dual;--当前指定id的会话...

SELECT  to_number('-321,909.10￥', '99999999999d99l', 'nls_currency= ''￥''')  FROM DUAL;l返回值中区域货币符号的位置g返回值中分组符的位置d返回值中小数点的位置select to_number('123,456.78','999999d999') from dual;...