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

³£ÓõÄһЩORACLEÃüÁî

²éÕÒÊý¾Ý¿âÖÐËùÓÐ×ֶΠ ÒÔ¶ÔÓ¦µÄ±í
select C.column_name,C.TABLE_NAME from dba_tab_columns C where owner=''
²éÿ¸ö¿ÆÄ¿class ·ÖÊýscroǰÈýÃû
select id, name, class, scro
   from (select row_number() over(partition by class order by scro desc)  cnt,
                id,
                name,
                class,
                scro
           from student) a
  where a.cnt <= 3;
²éÕÒÅÅÐòºóµÄǰÈýÐÐ
  select *
  from (select rw.*, rownum
          from (select *
                  from student d
                 where d.class = 'b'
                 order by d.scro desc) rw
         where rw.id >= 1
         order by rw.class desc) n
where rownum <= 3
±í¸´ÖÆ
insert into table_a (id,name,age) select b.id,b.name,b.age from table_b;
--ɾ³ý±íÊý¾ÝµÄ´¥·¢Æ÷
CREATE OR REPLACE PROCEDURE delete_data
IS
BEGIN
   delete from test ;
   COMMIT;
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      NULL;
   WHEN OTHERS
   THEN
      RAISE;
END delete_data;
--¶¨Ê±É¾³ý  ÿ¸ô5·ÖÖÓÖ´ÐÐÒ»´ÎµÄ¼Æ»®
DECLARE
  X NUMBER;
BEGIN
  SYS.DBMS_JOB.SUBMIT
&nbs


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âÍêÈ«Ð¶ÔØ

1¡¢ Í£Ö¹oracleËùÓеķþÎñ£¨¿ªÊ¼--ÔËÐÐ--ÊäÈëservices.msc£©
2¡¢ ɾ³ý×¢²á±íÉϵÄORACLEµÄÓйؼüÖµ(¿ªÊ¼-->ÔËÐÐ-->ÊäÈëregedit£©½«HKEY_LOACAL_MACHINE/SOFTWAREϵÄÖ÷¼üORACLEÈ«²¿É¾³ý¡£
3. ÏÂÃæÉ¾³ýOracle·þÎñ£º½øÈëHKEY_LOACAL_MACHINE/SYSTEMÖ÷¼üÏ£¬ÔÚControlSet001¡¢ControlSet002¡¢CurrentControlSet--> ......

oracle·Ö×é rollup,Cube

CUBE ºÍ ROLLUP Ö®¼äµÄÇø±ðÔÚÓÚ£º
CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£
ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£
     OracleµÄGROUP BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ·Ö³ÉÁ½´ó²½£º£¨1£©¶ÔÓÚ·ûºÏÌõ¼þµÄÿ ......

Oracle±í¿Õ¼ä³£ÓòÙ×÷

1. ²é¿´Oracle´´½¨¹ýÄÄЩÓû§
   >select username from all_users;
2. ²é¿´Oracle´´½¨¹ýÄÄЩ±í¿Õ¼ä£¬±í¿Õ¼äµÄÃû×ֺʹóС
   >select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
    from dba_tablespaces t, dba_data_files d
    wher ......

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â(1)
Oracle sql ÐÔÄÜÓÅ»¯µ÷Õû    1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
        ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a. RULE £¨»ùÓÚ¹æÔò£©  
b. COST £¨»ùÓڳɱ¾£©
c. CHOOSE £¨Ñ¡ÔñÐÔ£©
    ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶ ......

×Ô¶¯Íê³ÉOracle¿Í»§¶ËµÄ°²×°¼°ÆäÅäÖÃ


¡¡¡¡Ò»¡¢ÎÊÌâµÄÌá³ö
¡¡¡¡Ä¿Ç°µÄºÜ¶àÊý¾Ý¿âÓ¦ÓóÌÐòÊÇʹÓÃORACLEÊý¾Ý¿â¿ª·¢µÄclient/serverģʽ¡£ÖÚËùÖÜ
Öª£¬Ê¹ÓôËÖÖģʽÐèÒªÔÚÖÕ¶ËÉϰ²×°ORACLE¿Í»§¶ËÈí¼þ¡£Ó¦ÓóÌÐò¿ÉÒÔʹÓÃInstallShieldÈí¼þ´ò°ü³É°²×°³ÌÐò£¬ÓÉÓû§×ÔÐа²×°¡£µ«
ORACLE¿Í»§¶ËÈí¼þÒ»°ãÐèÒªÓо­ÑéµÄ¿ª·¢ÈËԱͨ¹ýÈË»ú½»»¥µÄ·½·¨°²×°£¬°²×°Íê³Éºó»¹ÐèÔ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ