ORACLE函数大全 ________________________________________ 作者:[本站编辑] 来源:[CSDN] 浏览:[ ] SQL中的单记录函数 1.ASCII 返回与指定的字符对应的十进制数; SQL> select ascii('A') A,ascii('a') a,ascii('0') zero,ascii(' ') space from dual; A A ZERO SPACE --------- --------- --------- ----
0、数据库参数属性col PROPERTY_NAME format a25col PROPERTY_VALUE format a30col DEscr iptION format a100select * from database_properties; select * from v$version; 1、求当前会话的SID,SERIAL#SELECT Sid, Serial# FROM V$sessionWHERE Audsid = Sys_Context('USERENV', 'SES
Oracle Built-in Functions Version 10.2 Function Name Analytic Collection Conver sion Date Time Data Mining Misc. Model Clause Null Handling Numeric Object String XML ABS ACOS ADD_MONTHS ADJ_DATE APPENDCHILDXML ASCII ASCIISTR ASIN ATAN ATAN2 AVG BFIL