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£¬ÈÕÆÚº¯Êý
Ïà¹ØÎĵµ£º
FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......
Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆÎª MMON µÄеĺó ......
ǰ¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕŰ×Ö½ÉÏ»³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......
2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......