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%)
Ïà¹ØÎĵµ£º
1.´´½¨±í£º
a. ´´½¨xs±íÖмÆËã»úרҵѧÉúµÄ±¸·Ý
Create table xs_jsj as select * from xs where zym=’¼ÆËã»ú’;
b.ÍêÕûµÄÀý×Ó£º
¡¡¡¡¡¡¡¡¡¡ Create table test ......
author£ºskate
time£º2010-05-31
ÎÒÃÇÔÚʹÓÃwindowsµÄʱºò£¬¶¼ÖªµÀÒª¶¨ÆÚÕûÀí´ÅÅÌË鯬£¬ÒòΪ´ÅÅÌË鯬»áÓ°ÏìÐÔÄÜ£¬¸ø¹ÜÀíÉÏ´øÀ´¶îÍâµÄ
¸ºµ£¡£ÄÇoracle¸üÊÇÈç´Ë£¬µ±Ëæ×ÅÊý¾ÝÔö¼Ó£¬oracle´¦Àíº£Á¿Êý¾Ý±¾Éí¾ÍÒѾºÜ·ÑÁ¦Á˰¡£¬Èç¹ûÔÙÓдóÁ¿
µÄË鯬£¬ÄǾÍÊÇÑ©ÉϼÓ˪°¡¡£ËùÒÔËéÆ¬ÒªÒýÆðdbaµÄ¸ß¶ÈÖØÊÓ£¬¾¡Ôç·¢ÏÖ¾¡Ôç´¦Àí¡£
莮 ......
Ê×ÏÈдºÃ½¨¿â½Å±¾c.sql
¡¡¡¡
¡¡¡¡create database mydb
¡¡¡¡controlfile reuse
¡¡¡¡maxinstances 1
¡¡¡¡maxloghistory 1
¡¡¡¡maxlogfiles 5
¡¡¡¡maxlogmembers 5
¡¡¡¡maxdatafiles 100
¡¡¡¡datafile '$ORACLE_HOME/oradata/system01.dbf'size 325M reuse
¡¡¡¡autoextend on next 10240K maxsize unlimited
¡¡¡¡u ......
Oracle10GµÄEM²ÉÓÃÁËweb·½Ê½£¬²¢ÇÒ·Ö³ÉÁË2¸ö²úÆ·£¬database controlºÍgrid control¡£ÕâÀïÖ÷Òª½éÉÜÈçºÎ´´½¨µ¥Êý¾ÝµÄdbcontrol¡£Grid controlÐèÒªÏÂÔØµ¥¶ÀµÄ¹âÅ̰²×°¡£
ÔÚÓÃDBCA½¨¿âµÄʱºò£¬¿ÉÒÔÑ¡ÔñÊÇ·ñÆôÓÃdbcontrol£¬ÆôÓõϰÐèÒªÔÚ
Êý¾Ý¿â
Öн¨Á¢Ò»¸ösysmanµÄschema£¬ÓÃÓÚ±£´æEMµÄһЩÊý¾Ý£¬Õâ¸ö¾ÍÊÇEMµÄ×ÊÁÏ¿â(reposi ......
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê ÏÔʾֵ:07
yyy three digits ÈýλÄê ......