oracle Function
5.µ÷Óú¯ÊýFN_ADDONE
--------------------
SQL> SET SERVEROUTPUT ON
SQL> DECLARE CNUM NUMBER;
2 BEGIN
3 CNUM := USER1_ADB.FN_ADDONE(3);
4 DBMS_OUTPUT.PUT_LINE('CNUM = ' || CNUM);
5 END;
6 /
CNUM = 4
PL/SQL ¹ý³ÌÒѳɹ¦Íê³É¡£
6.ɾ³ýº¯ÊýFN_ADDONE
--------------------
SQL> DROP FUNCTION USER1_ADB.FN_ADDONE;
Ïà¹ØÎĵµ£º
±ítask£¬×Ö¶Îid_£¬name_
id_µÄÊý¾ÝÈçÏÂÐÎʽ£º
1
1.1
1.1.1
1.1.1.2
1.2
1.2.1
...
10
10.1
10.1.1
10.2.1
10.2.1.1
10.2.1.1.1
10.2.1.1.2
.......
×¢£º“.”±êʶ¸¸×ӵĹØÏµ¡£
ÏÖÔÚͨ¹ýid_²éѯÊ÷½á¹¹µÄЧ¹û£¬²¢ÇÒÖªµÀ´Ë½ÚµãÊÇ·ñΪҶ×Ó½Úµãleaf¡£¡££¿
Óï¾äÈçÏ£º
select
......
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24
DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides suppo ......
select column_name from all_cons_columns cc
where owner='SSH' --SSHΪÓû§Ãû³Æ£¬Òª×¢Òâ´óСд
and table_name='SYS_DEPT' --SYS_DEPTΪ±íÃû£¬×¢Òâ´óСд
and exists (select 'x' from all_constraints c
where c.owner = cc.owner
and c.constraint_name = cc.constraint_name
and c.constraint_type ='P'
......
1.²é¿´ËùÓÐÓû§
select * from all_users; -------²é¿´ËùÓеÄÓû§
select * from user_users; --------²é¿´µ±Ç°Óû§
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
select * from user_sys_privs; --------²é¿´µ±Ç°Óû§µÄȨÏÞ
3.²é¿´½ÇÉ«Ëù°üº¬µÄȨÏÞ
&nb ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......