Oracle Application ExpressÆô¶¯·þÎñ
Æô¶¯xxService ¸úÒ»¸öxxxListener µÄ·þÎñ
怬Oracle Application Express
Oracle Application Express (Oracle APEX) ÊÇÒ»¸öÓÃÓÚ Oracle Êý¾Ý¿âµÄ¿ìËÙ Web Ó¦ÓóÌÐò¿ª·¢¹¤¾ß¡£½öƾ½è Web ä¯ÀÀÆ÷ºÍÓÐÏ޵ıà³Ì¾Ñ飬¾ÍÄÜ¿ìËÙ¿ª·¢ºÍ²¿Êð³ö°²È«µÄרҵӦÓóÌÐò¡£
http://localhost:8080/apex
ÊäÈëÓû§Ãû(System)¡¢ÃÜÂë(°²×°Ê±ºòÌîдµÄÃÜÂë)
Ïà¹ØÎĵµ£º
ROLLUPºÍCUBEÓï¾ä¡£
OracleµÄGROUP
BYÓï¾ä³ýÁË×î»ù±¾µÄÓï·¨Í⣬»¹Ö§³ÖROLLUPºÍCUBEÓï¾ä¡£Èç¹ûÊÇROLLUP(A, B, C)µÄ»°£¬Ê×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºó¶Ô(A¡¢B)½øÐÐGROUP BY£¬È»ºóÊÇ(A)½øÐÐGROUP BY£¬×îºó¶ÔÈ«±í½øÐÐGROUP BY²Ù×÷¡£Èç¹ûÊÇGROUP BY
CUBE(A, B, C)£¬ÔòÊ×ÏÈ»á¶Ô(A¡¢B¡¢C)½øÐÐGROUP
BY£¬È»ºóÒÀ´ÎÊÇ(A¡ ......
¡¡¡¡±¾ÎĽéÉÜÁËÔÚOracleÊý¾Ý¿âÖУ¬¶ÔÈÕÆÚ¡¢Ê±¼äµÄ¸÷ÖÖ²Ù×÷£¬°üÀ¨£ºÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷¡¢ÈÕÆÚµ½×Ö·û²Ù×÷¡¢×Ö·ûµ½ÈÕÆÚ²Ù×÷¡¢trunk / ROUNDº¯ÊýµÄʹÓᢺÁÃ뼶µÄÊý¾ÝÀàÐ͵ȡ£
1.ÈÕÆÚʱ¼ä¼ä¸ô²Ù×÷
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7·ÖÖÓµÄʱ¼ä
¡¡¡¡select sysdate,sysdate - interval '7' MINUTE from dual
¡¡¡¡µ±Ç°Ê±¼ä¼õÈ¥7СʱµÄʱ¼ä
¡¡¡ ......
QQ:1156316388 Tel:010-51527259
1.À䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐģʽµÄÊý¾Ý¿â¡£Èȱ¸·ÝµÄÓŵã ......
OracleÄÚÖýÇÉ«connectÓëresourceµÄȨÏÞ
============================================================
Ò»¡¢ºÎΪ½ÇÉ«£¿
¡¡¡¡Èç¹ûÓÐÒ»×éÈË£¬ËûÃǵÄËùÐèµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶ÔËûÃǵÄȨÏÞ½øÐйÜÀíµÄʱºò»á²»·½±ã¡£ÒòΪÄãÒª¶ÔÕâ×éÖеÄÿ¸öÓû§µÄȨÏÞ¶¼½øÐйÜÀí¡£
¡¡¡¡ÓÐÒ»¸öºÜºÃµÄ½â¾ö°ì·¨¾ÍÊÇ£º½ÇÉ«¡£½ÇÉ«ÊÇÒ»×éȨÏ޵ļ ......