Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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;


Ïà¹ØÎĵµ£º

OracleÇý¶¯classes12.jar Óëojdbc14.jarµÄÇø±ð

ÒÔÏÂÊÇOracle JDBC¹Ù·½ÎĵµµÄ˵·¨£º
Ò²¾ÍÊÇËæ±ã·­ÒëһϾÍÀí½âÁË¡£
JDBC Thin for All Platforms
classes12.jar (1,600,090 bytes) - for use with JDK 1.2 and JDK 1.3
Ôڵͼ¶JDK°æ±¾1.2Óë1.3ÖÐʹÓõÄÇý¶¯£¬ËäȻʵ¼ÊÉÏÔÚ1.4£¬1.5ÖÐʹÓô󲿷ÖÇé¿öÒ²ÊÇOKµÄ
classes12_g.jar (2,044,594 bytes) - same as classes12.j ......

ÔÚORACLEµÃµ½Ä³¸ö±íµÄÖ÷¼ü×Ö¶ÎÃû

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' ......

oracle ·ÖÇø±íµÄ½¨Á¢·½·¨

oracle ·ÖÇø±íµÄ½¨Á¢·½·¨ 

OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö· ......

Oracle ²é¿´Óû§È¨ÏÞÒÔ¼°Ë÷Òý

1.²é¿´ËùÓÐÓû§
     select * from all_users; -------²é¿´ËùÓеÄÓû§
     select * from user_users; --------²é¿´µ±Ç°Óû§
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
     select * from user_sys_privs; --------²é¿´µ±Ç°Óû§µÄȨÏÞ
3.²é¿´½ÇÉ«Ëù°üº¬µÄȨÏÞ
&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ