¹ØÓÚORACLE Éó¼ÆµÄһЩÊÓͼºÍ½Å±¾
Éó¼ÆÊÓͼ
STMT_AUDIT_OPTION_MAP -- Éó¼ÆÑ¡ÏîÀàÐÍ´úÂë
AUDIT_ACTIONS -- action´úÂë
ALL_DEF_AUDIT_OPTS -- ¶ÔÏó´´½¨Ê±Ä¬ÈϵĶÔÏóÉó¼ÆÑ¡Ïî
DBA_STMT_AUDIT_OPTS -- µ±Ç°Êý¾Ý¿âϵͳÉó¼ÆÑ¡Ïî
DBA_PRIV_AUDIT_OPTS -- ȨÏÞÉó¼ÆÑ¡Ïî
DBA_OBJ_AUDIT_OPTS
USER_OBJ_AUDIT_OPTS -- ¶ÔÏóÉó¼ÆÑ¡Ïî
DBA_AUDIT_TRAIL
USER_AUDIT_TRAIL -- Éó¼Æ¼Ç¼
DBA_AUDIT_OBJECT
USER_AUDIT_OBJECT -- Éó¼Æ¶ÔÏóÁбí
DBA_AUDIT_SESSION
USER_AUDIT_SESSION -- sessionÉó¼Æ
DBA_AUDIT_STATEMENT
USER_AUDIT_STATEMENT -- Óï¾äÉó¼Æ
DBA_AUDIT_EXISTS -- ʹÓÃBY AUDIT NOT EXISTSÑ¡ÏîµÄÉó¼Æ
DBA_AUDIT_POLICIES -- Éó¼ÆPOLICIES
DBA_COMMON_AUDIT_TRAIL -- ±ê×¼Éó¼Æ+¾«Ï¸Éó¼Æ
һЩ½Å±¾
ÏÂÃæÕâ¸ö½Å±¾¿ÉÒÔÕÒ³öϵͳ¿ªÁËÄÄЩ ϵͳÉó¼Æ¹¦ÄÜ(·Çobject Éó¼Æ)
select nvl(user_name,'SYSTEM WIDE AUDITING')"User_Name",proxy_name "Proxy_Name",audit_option "Audit_Option",
success "Success?",failure "Failure?" from DBA_STMT_AUDIT_OPTS;
Àý×Ó£º
SQL> select nvl(user_name,'SYSTEM WIDE AUDITING')"User_Name",proxy_name "Proxy_Name",audit_option "Audit_Option",
2 success "Success?",failure "Failure?" from DBA_STMT_AUDIT_OPTS;
User_Name Proxy_Name Audit_Option Success? Failure?
------------------------------ ------------------------------ ---------------------------------------- ---------- -----
Ïà¹ØÎĵµ£º
PL/SQL µÄÒì³£(Ô¤¶¨ÒåÒì³£)
2009-08-13 20:24
Òì³£Ãû³Æ & ......
´æ´¢¹ý³Ì´´½¨Óï·¨£º
£¨1£©ÎÞ²Î
create or replace procedure ´æ´¢¹ý³ÌÃû
as
±äÁ¿1 ÀàÐÍ£¨Öµ·¶Î§£©;
±äÁ¿2 ÀàÐÍ£¨Öµ·¶Î§£©;
Begin
........................
Exception
........................
End;
£¨2£©´ø ......
linux Ï°²×°oracle ÊÇÒ»¼þºÜÁîÈËÍ·ÌÛµÄÊÂÇ飬ÎÒ°Ñ×Ô¼ºµÄ°²×°²½ÖèÄóöÀ´¸ø´ó¼Ò·ÖÏíһϡ£
Ò».linux·þÎñ¶ËµÄ°²×°.
1.ÏÂÔØoracle·þÎñ¶ËÈí¼þ,ÏÂÔØÍøÖ·ÈçÏÂ
http://www.oracle.com/technology/software/products/database/index.html
ÎÒÑ¡ÔñµÄ°æ±¾ÊÇ£ºOracle Database 10g Release 2 (10.2.0.1.0) for Linux x86-64
......
<< 1 >>
decode()º¯數ʹÓü¼ÇÉ
·Èí¼þ»·¾³£º
1¡¢Windows NT4.0+ORACLE 8.0.4
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORANT
·º¬Òå½âÊÍ£º
decode(Ìõ¼þ,Öµ1,·ÒëÖµ1,Öµ2,·ÒëÖµ2,...Öµn,·ÒëÖµn,ȱʡֵ)
¸Ãº¯ÊýµÄº¬ÒåÈçÏ£º
IF Ìõ¼þ=Öµ1 THEN
¡¡¡¡¡¡¡¡RETURN(·ÒëÖµ1)
ELSIF Ìõ¼þ=Öµ2 THEN
¡¡¡ ......
MDSYS.CS_SRS ----- ¸Ã±í¶¨ÒåÁË×ø±êϵµÄÃû×Ö¼°ÆäÔÚOracle SpatialÖеÄIDÖµµÈ£¬ÕâЩ×ø±êϵ¶¼ÊÇÓÉOpen-GIS¹«²¼µÄ¡£Ä¿Ç°¶¨ÒåµÄ×ø±êϵÒѾ´ïµ½1018¸ö¡£
MDSYS.SDO_ANGLE_UNITS ----- ¸Ã±í¶¨ÒåÁ˽Ƕȵ¥Î»£¬·Ö±ðÊÇDegree,Gon,Grad,Minute,Radian,Second
MDSYS.SDO_DIST_UNITS ----- ¸Ã±í¶¨ÒåÁ˾àÀëµÄµ¥Î»¡£±ÈÈçkm,m£¬¹²ÓÐ27ÖÖ¾à ......