ΪʲôoracleÆÕͨÓû§¿ÉÒÔÑ¡ÔñdbaÄܵǼ³É¹¦ÄØ
Ç°¼¸Ìì²Ù×÷Öз¢Ïֵģ¬Ò²²»ÖªµÀÊDz»ÊÇÎÒûÓиÄÅäÖû¹ÊÇÔõôµÄ£¬ÎÒ±¾È˵ÄÊý¾Ý¿â¾ÍÊÇĬÈÏ°²×°µÄ£¬È»ºó½«scottÓû§½âËøÁË£¬scottÓû§Ó¦¸ÃÊÇÆÕͨÓû§£¬¶ø²»ÊÇDBAÓû§¡£°´ÕÕ³£Àí·ÖÎö˵£¬ËûÓ¦¸ÃÊDz»ÊÇÄܹ»½øÈëϵͳ£¬Ò»°ãµÄʱºò£¬É趨ȨÏÞµÄʱºò¶¼»áÕâÑùÉè¡£
ÎÒ½«excelµÄÊý¾Ýµ¼ÈëoracleÖУ¬Ö´ÐеÄÈÕÖ¾ÎļþÖУ¬ÒѾ˵Õý³£µÄµ¼ÈëÊý¾Ý£¬Ã»ÓдíÎó£¬È»ºó£¬ÎÒÔÚPL/SQLÖвéѯ£¬ÔõôҲûÓв鵽Êý¾Ý£¬£¨´ËʱÎÒÓõÄÊÇscott£¬µ«ÊÇ£¬½ÇÉ«Ñ¡ µÄÊÇDBA£©£¬È»ºó£¬ÎÒÒ»Ö±ÔÚÕÒÎÒµ¼ÈëÊý¾ÝµÄÔÒò£¬ºóÀ´°Ñ»º³åÇøµ÷СÁË£¬×Ô¶¯Ìá½»Ò²ÉèÖÃÁË£¬Ò²»¹ÊÇûÓУ¬ÆäʵÕâÖ»ÊÇÎÒÑ¡ÔñÁËDBAµÇ¼µÄÔÒò¡£µ«ÊÇ£¬´ËʱÄܽ«Êý¾ÝÔö¼Ó½øÈëÊý¾Ý±í(insertÊÇÄÜÕýÈ·Ö´ÐеÄ)¡£¶øÇÒÄܲéÕÒµ½¡£
´ÓȨÏÞ·½ÃæÀ´·ÖÎö£¬Ò»°ã²éѯµÄȨÏޱȲÙ×÷µÄȨÏÞÒªËÉ£¬ÎªÊ²Ã´ÄܲÙ×÷´Ë±í£¬¶øÈ´²éÕÒ²»µ½´Ó±ð´¦Ìí¼Ó½øÀ´µÄÊý¾Ý,²»Ã÷°×¡£
Ïà¹ØÎĵµ£º
select trim(leading | trailing | both ' ' from ' abc d ') from dual;
È¥µô×Ö·û´® ' abc d ' µÄÇ°Ãæ/ºóÃæ/Ç°ºóµÄ¿Õ¸ñ
ÀàËƺ¯Êý£ºltrim, ......
½ñÌìÔÚÒ»¸öÌû×ÓÀï¿´µ½shiyiwanµÄ»ØÌûÖÐÌá¼°µ½ÁËÁ½¸ö×Ô¼ºÒÔǰû¼û¹ýµÄ¸ÅÄsave exceptionºÍdml error logging¡£ÉÏÍøËÑÁËËÑÏà¹ØÄÚÈÝ£¬¿´ÁË¿´´ó¸ÅÃ÷°×Òâ˼£¬²»¹ýÔÚʵ¼ÊÔËÓÃÖл¹ÊÇûÔõôÓùý¡£±£´æÏÂÀ´£¬ÒÔºóÓõĵ½µÄ»°·½±ã²éÔÄ¡£
ÕâһƪÊǹØÓÚsave exceptionµÄ£¬ÁíÍâһƪdml error loggingµÄ²Î¼ûÈçÏÂÁ´½Ó
http://blog.csdn ......
×÷Õߣº ÈÕÆÚ£º2005-12-8 1:43:32 À´Ô´£ºInternet µã»÷£º´Î ÆÀÂÛ
¡¡¡¡±¾ÎÄÖ»ÌÖÂÛOracleÖÐ×î³£¼ûµÄË÷Òý£¬¼´ÊÇB-treeË÷Òý¡£±¾ÎÄÖÐÉæ¼°µÄÊý¾Ý¿â°æ±¾ÊÇOracle8i¡£
¡¡¡¡Ò». ²é¿´ÏµÍ³±íÖеÄÓû§Ë÷Òý
¡¡¡¡ÔÚOracleÖУ¬SYSTEM±íÊÇ°²×°Êý¾Ý¿âʱ×Ô¶¯½¨Á¢µÄ£¬Ëü°üº¬Êý¾Ý¿âµÄÈ«²¿Êý¾ ......
ÈçºÎ¶¨ÒåÓαêÀàÐÍ
TYPE ref_type_name IS REF CURSOR [RETURN return_type];
ÉùÃ÷Óαê±äÁ¿
cursor_name ref_type_name;
´Ó¼¼Êõµ×²ã¿´£¬Á½ÕßÊÇÏàͬµÄ¡£ÆÕͨplsql cursorÔÚ¶¨ÒåʱÊÇ“¾²Ì¬”µÄ¡£¶øRef cursors¿ÉÒÔ¶¯Ì¬´ò¿ª¡£
ÀýÈçÏÂÃæÀý×Ó£º
Declare
type rc is ref cursor;
cursor c is select * from dual ......
ɾ³ýOracleÖ®Ò»
Èí¼þ»·¾³£º 1¡¢Windows 2000+ORACLE 8.1.7
2¡¢ORACLE°²×°Â·¾¶Îª£ºC:\ORACLE
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ£¬Í£Ö¹ËùÓÐOracle·þÎñ¡£
2¡¢ ¿ªÊ¼££¾³ÌÐò££¾Oracle - OraHome81££¾O ......