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

oracle_°Ù·Ö±È¼ÆËã

select round(sum(case when o.close_date is null then 1 else 0 end)/count(*),3)*100||'%'  SCALE from order o
˵Ã÷£ºÊ¹ÓÃsum¶ÔÒ»¶¨Ìõ¼þµÄÊý¾ÝÇóºÍºó£¬Óë×ÜÊý½øÐбȽϡ£
         ||'%' ÎªÒԵİٷֺÅÐÎʽÊä³ö½á¹û(Àý£º2%)


Ïà¹ØÎĵµ£º

Oracle¶àÐмǼºÏ²¢/Á¬½Ó/¾ÛºÏ×Ö·û´®µÄ¼¸ÖÖ·½·¨

ʲôÊǺϲ¢¶àÐÐ×Ö·û´®£¨Á¬½Ó×Ö·û´®£©ÄØ£¬ÀýÈ磺
SQL> desc test;
Name     Type          Nullable Default Comments
------- ------------ -------- ------- --------
COUNTRY VARCHAR2(20) Y       &nb ......

oracle ²Ù×÷±íʾÀý

1.´´½¨±í£º
       a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
           Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
       b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......

OracleµÄredo ºÍundoµÄÇø±ð

дµÄ´ÎÐò:
redo--> undo-->datafile
insertÒ»Ìõ¼Ç¼ʱ, ±í¸úundoµÄÐÅÏ¢¶¼»á·Å½ø redo ÖÐ, ÔÚcommit »ò֮ǰ, redo µÄÐÅÏ¢»á·Å½øÓ²ÅÌÉÏ. ¹ÊÕÏʱ, redo ±ã¿É»Ö¸´ÄÇЩÒѾ­commit Á˵ÄÊý¾Ý.
redo->ÿ´Î²Ù×÷¶¼ÏȼǼµ½redoÈÕÖ¾ÖУ¬µ±³öÏÖʵÀý¹ÊÕÏ£¨Ïñ¶Ïµç£©£¬µ¼ÖÂÊý¾ÝδÄܸüе½Êý¾ÝÎļþ£¬ÔòÊý¾Ý¿âÖØÆôʱÐëredo£¬ÖØÐ ......

oracleË÷ÒýË鯬

author£ºskate
time£º2010-05-31
Ë÷ÒýÒ³¿éË鯬£¨Index Leaf Block Fragmentation£©
ÕâÆªÎÄÕ½«»á»Ø´ðÈçÏÂÎÊÌ⣺
ʲôÊÇË÷ÒýÒ³¿éË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
ʲôÊǰë¿ÕË÷ÒýË鯬£¿Ê²Ã´Ê±ºò±»ÖØÓã¿
oracleµÄ±ê×¼Ë÷Òý½á¹¹ÊÇB×tree½á¹¹£¬Ò»¸öB×tree½á¹¹ÓÉÈýÖÖblock×é³É
¸ù¿é(root block):ÔÚB×treeÀïÓÐÇÒÖ ......

Oracle±í¿Õ¼äµÄ½¨Á¢

CREATE TABLESPACE mySpace
datafile
'd:\data\data1.dbf' size 1M reuse
autoextend on next 100k maxsize 2M
'd:\data\data2.dbf' size 1M reuse
online
permanent;
ÆäÖÐonline±íÁª»ú¡£
Áª»úºÍÍÑ»úµÄÇø±ðºÍʹÓÃ
Áª»ú£º ORACLE·þÎñ½ø³Ì¹ØÁªÎļþ¡£¿É¹©oracle¿Í»§¶Ë·ÃÎÊ.Èç¹ûÔÚϵͳÖÐÖ±½Óɾ³ýʱ»áµ¯³öÒì³£¡£
ÍÑ»ú: ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ