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

Oracle֪ʶ£¨¶þ£©

 
OracleÊý¾Ý¿âº¯Êý£¨µ¥Ðк¯Êý£©
 
OracleÖеĺ¯ÊýºÍCÖеĺ¯Êý²î²»¶à£¬Ò²ÊÇÓк¯ÊýÃû£¬²ÎÊý±í£¬ºÍ·µ»ØÖµÀàÐÍ×é³ÉµÄ£¬µ¥Ðк¯Êý£¬ÊÇÕë¶ÔÿÌõ¼Ç¼¶¼ÓÐÒ»¸ö½á¹û¡£µ¥Ðк¯Êý¿ÉÒÔ³öÏÖÔÚselect ºóÃæ£¬Ò²¿ÉÒÔ³öÏÖÔÚwhere×Ó¾äÖС£
 
ÐèÒª´¦ÀíÏÖʵµÄ½á¹ûʱ£¬¾Í°Ñº¯ÊýдÔÚselectºóÃæ£¬ÓÃÓÚÌõ¼þ¹ýÂËʱ£¬¾Í°Ñº¯ÊýÓÃÔÚwhere×Ó¾äÖС£
 
1,×Ö·ûº¯Êý£¨varchar£©
 
   ×Ö·ûÊÇ´óСдÃô¸ÐµÄ
   ×ªÐ¡Ð´ lower(‘...’)
   ×ª´óд upper(‘...’)
   Ê××Öĸ´óд initcap(‘...’)
   dual±í£¬ÊÇרÃÅÓÃÓÚº¯Êý²âÊÔºÍÔËËãµÄ£¬ËûÖ»ÓÐÒ»Ìõ¼Ç¼    
   ×Ö·û´®Æ´½Ó concat(‘...’,’....’)
   ÇóÖ¸¶¨×Ó´® substr(‘...’,ÆðʼλÖã¬È¡×Ö·û¸öÊý)(ÆðʼλÖÿÉÒÔΪ¸º)
   ÇóÖÆ¶¨×Ö·û´®µÄ³¤¶Èlength(‘……’)
   ¿ÉÒÔʹÓÃ"-"±íʾ´ÓÓÒÏò×óÈ¡£¬È¡µÄʱºò¿ÉÒÔ´Ó×óÍùÓÑÈ¡¡£
Àý£º
       select upper(‘test’) from dual;
    select first_name from s_emp where upper(first_name)=’GEORGE’;
select substr(first_name,-2,2) sub from s_emp;£¨È¡ºóÁ½¸ö£©
       select substr(first_name,2,2) sub from s_emp;£¨È¡Ç°Á½¸ö£©
 
2,ÊýÖµº¯Êý£¨number£©
 
   ËÄÉáÎåÈë round(Êý¾Ý,±£ÁôСÊýµãºó¼¸Î»)
   ¿ÉÒÔÓøºÊý±íʾСÊýµãǰ£¬0£¬±íʾСÊýµãºóµÚһ룬Ҳ¾ÍÊDZ£Áô¸ö룬-1±íʾ¸ö루±£Áôµ½Ê®   Î»£©¡£
   Àý£ºselect round(15.36,1) from dual;
   ½á¹û£º15.4
 
   ½ØÈ¡Êý×Öº¯Êý trunc(Êý¾Ý£¬±£ÁôµÄλÊý£¨Ð¡ÊýµãºóλÊý£©) ½ØÈ¡¸öλ֮ºó²¹0
   Àý£ºselect trunc(123.456,-1) from dual; ±£Áôµ¹Ê®Î»
   ½á¹û£º120
 
3£¬ÈÕÆÚº¯Êý
 
   


Ïà¹ØÎĵµ£º

oracle forallÓï¾ä

 FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......

Oracle AWR ½éÉÜ

Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆÎª MMON µÄеĺó ......

oracle Ìåϵ½á¹¹

ǰ¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕŰ×Ö½ÉÏ»­³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......

ORACLE°²×°Ö®ºóµÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·

2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
     OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼­±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
     Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ