oracle ÊýÖµ±£ÁôСÊýµãÎÊÌâ ÔÚÏßµÈ! - Oracle / ¿ª·¢
select x from ±í xÊÇnumberÀàÐÍ,°üº¬ÓÐÁ½Î»Ð¡Êý x²é³öÀ´Ê±±»×Ô¶¯È¥µôºóÃæÐ¡ÊýµãµÄ0 È磺 0 3.1 ÏÖÔÚÎÒÏë±£ÁôËüÊÇnumberÀàÐÍ£¬¶øÇÒ°üº¬Á½Î»Ð¡Êý ¼´ÎÒÏëÒªµÄ½á¹ûΪ 0.00 3.10 ÏÈлл´ó¼Ò!
°ÑxµÄÊý¾ÝÀàÐ͸ÄΪnumber(11,2) ¶þÂ¥²é³öÀ´µÄÊÇ×Ö·ûÐÍ£¬²»·ûºÏÐèÇó°¡ ÎÒ±í½á¹¹ÒѾÊÇnumber(18,2) ÏÖÔÚÎÒÇó³öÀ´½á¹ûÒ»sumºóºóÃæÐ¡Êýµã¾ÍûÁË ¶øÎÒºóÃæ»¹ÐèÒªÄÃÕâ¸ö½á¹ûÀ´union all µ±ÎÒÏñ¶þÂ¥ÄÇÑùдµÄʱºò union all ʱ¾Í»áÌáʾÊý¾ÝÀàÐͲ»Æ¥ÅäÒýÓà ¶þÂ¥²é³öÀ´µÄÊÇ×Ö·ûÐÍ£¬²»·ûºÏÐèÇó°¡ ÎÒ±í½á¹¹ÒѾÊÇnumber(18,2) ÏÖÔÚÎÒÇó³öÀ´½á¹ûÒ»sumºóºóÃæÐ¡Êýµã¾ÍûÁË ¶øÎÒºóÃæ»¹ÐèÒªÄÃÕâ¸ö½á¹ûÀ´union all µ±ÎÒÏñ¶þÂ¥ÄÇÑùдµÄʱºò union all ʱ¾Í»áÌáʾÊý¾ÝÀàÐͲ»Æ¥Åä ×îºÃÊÇÈ«²¿´úÂë ÄǾÍÏÈsum(x) È»ºóÔÚto_char(sum(x),'fm999990.00') from tb SQL code: Select * from F_NEWTRACKMONTHHR t1 where t1.date_id = 201004 union all select t.date_id date_id, t.managecom_id managecom_id, t.initgrade initgrade, t.companyage companyage, t.reporttype reporttype, sum(t.begin_agent_num) begin_agent_num, sum(t.end_agent_num) end_agent_num, sum(t.active_agent_num) active_agent_num, sum(t.satisfy_agent_num) satisfy_agent_num, su
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡ ×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½ ´¥·¢Æ÷? Ó¦¸ÃÓÃJOB Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......