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

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî

oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨ ¼°×¢ÒâÊÂÏî
oracle ´æ´¢¹ý³ÌµÄ»ù±¾Óï·¨
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
    ²ÎÊý1 IN NUMBER,
    ²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
  ½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿ÖУ¬±ØÐëÓÐÒ»Ìõ
  ¼Ç¼£¬·ñÔòÅ׳öÒì³£(Èç¹ûûÓмǼÅ׳öNO_DATA_FOUND)
  Àý×Ó£º
  BEGIN
  SELECT col1,col2 into ±äÁ¿1,±äÁ¿2 from typestruct where xxx;
  EXCEPTION
  WHEN NO_DATA_FOUND THEN
      xxxx;
  END;
  ...
3.IF ÅжÏ
  IF V_TEST=1 THEN
    BEGIN
       do something
    END;
  END IF;
4.while Ñ­»·
  WHILE V_TEST=1 LOOP
  BEGIN
 XXXX
  END;
  END LOOP;
5.±äÁ¿¸³Öµ
  V_TEST := 123;
6.ÓÃfor in ʹÓÃcursor
  ...
  IS
  CURSOR cur IS SELECT * from xxx;
  BEGIN
 FOR cur_result in cur LOOP
  BEGIN
   V_SUM :=cur_result.ÁÐÃû1+cur_result.ÁÐÃû2
  END;
 END LOOP;
  END;
7.´ø²ÎÊýµÄcursor
  CURSOR C_USER(C_ID NUMBER) IS SELECT NAME from USER WHERE TYPEID=C_ID;
  OPEN C_USER(±äÁ¿Öµ);
  LOOP
 FETCH C_USER INTO V_NAME;
 EXIT FETCH C_USER%NOTFOUND;
    do something
  END LOOP;
  CLOSE C_USER;
8.ÓÃpl/sql developer debug
  Á¬½ÓÊý¾Ý¿âºó½¨Á¢Ò»¸öTest WINDOW
  ÔÚ´°¿ÚÊäÈëµ÷ÓÃSPµÄ´úÂë,F9¿ªÊ¼debug,CTRL+Nµ¥²½µ÷ÊÔ
¹ØÓÚoracle´æ´¢¹ý³ÌµÄÈô¸ÉÎÊÌⱸÍü
1.ÔÚoracleÖУ¬Êý¾Ý±í±ðÃû²»ÄܼÓas£¬È磺
select a.appname from appinfo a;-- ÕýÈ·
select a.appname from appinfo as a;-- ´íÎó
 Ò²Ðí£¬ÊÇźÍoracleÖеĴ洢¹ý³ÌÖеĹؼü×Öas³åÍ»µÄÎÊÌâ°É
2.ÔÚ´æ´¢¹ý³ÌÖУ¬selectijһ×Ö¶Îʱ£¬ºóÃæ±ØÐë½ô¸úinto£¬Èç¹ûselectÕû¸ö¼Ç¼£¬ÀûÓÃÓαêµÄ»°¾ÍÁíµ±±ðÂÛÁË¡£
  select af.keynode&nb


Ïà¹ØÎĵµ£º

oracle²é¿´±»ËøµÄ±íºÍ½âËø

²é¿´Ëø±í½ø³ÌSQLÓï¾ä1£º
select sess.sid,
    sess.serial#,
    lo.oracle_username,
    lo.os_user_name,
    ao.object_name,
    lo.locked_mode
    from v$locked_object lo,
    dba_ ......

OracleÊý¾Ý¿â8i¡¢9iĬÈÏÓû§´æÔÚÈõ¿ÚÁî

ΪÕâЩÓû§ÃûÉèÖÃ×㹻ǿ׳µÄ¿ÚÁî»òËø¶¨ÎÞÓõÄĬÈÏÓû§¡£
SQLÓï¾äÐ޸ģº
Á¬½ÓÖÁOracleºóʹÓÃÈçÏÂÃüÁîÐ޸ĿÚÁî:
alter user system£¨Óû§Ãû£© identified by manager£¨ÃÜÂ룩;
Á¬½ÓÖÁOracleºóʹÓÃÈçÏÂÃüÁîËø¶¨Õ˺Å:
alter user test£¨Óû§Ãû£© account lock;
 
ͼÐδ°¿ÚÐ޸ģº
Oracle·þÎñopenviewÉϵÄÓû§£ºSCOT ......

oracle ×Ö·û¼¯

²é¿´oracle·þÎñÆ÷×Ö·û¼¯:select * from nls_database_parameters where parameter = 'NLS_CHARACTERSET'
ʹÓÃPl/SQL ²éѯÊý¾ÝʱÂÒÂë,²åÈëÊý¾ÝʱÂÒÂë
Êý¾Ý¿â·þÎñÆ÷µÄ×Ö·û¼¯ºÍ¿Í»§¶ËµÄ×Ö·û¼¯²»Í¬ËùÔì³ÉµÄ,ÐÞ¸ÄÊý¾Ý¿â¿Í»§¶ËµÄ×Ö·û¼¯ºÍ·þÎñÆ÷µÄ×Ö·û¼¯Ò»ÖÂ
²Ù×÷·½·¨:
   oracle 9i :Ð޸ı¾µØ×¢²á±íÖÐORACLE¿Í»§¶Ëµ ......

Oracle 9iÐÔÄܵ÷Õû


Oracle 9iÐÔÄܵ÷Õû
/* *
×÷Õß:Å·³¯¾´
QQ:35712069
ÊÖ»ú:13873195792
Çë×ªÔØÕß²»Òª¸ü¸ÄÔ­°æÄÚÈÝ
 */
1¡¢ÉèÖúÏÊʵÄSGA
¡¡¡¡³£³£ÓÐÈ˱§Ô¹·þÎñÆ÷Ó²¼þºÜºÃ£¬µ«ÊÇOracle¾ÍÊǺÜÂý¡£ºÜ¿ÉÄÜÊÇÄÚ´æ·ÖÅä²»ºÏÀíÔì³ÉµÄ¡£
¡¡¡¡(1)¼ÙÉèÄÚ´æÓÐ512M£¬Õâͨ³£ÊÇСÐÍÓ¦Ó᣽¨ÒéOracleµÄSGA´óÔ¼240M£¬ÆäÖУº¹²Ïí³Ø£¨SHARED_POOL ......

oracle³£¼ûÓï¾ä

----±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
select * from user_sys_privs;
---±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡select * from user_tab_privs;
-----Ìí¼ÓȨÏÞ
GRANT CREATE USER,DROP  USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY  VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE&nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ