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

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


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

¹ØÓÚOracle´¥·¢Æ÷µÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

Ö÷ÒªÏëʵÏÖ£ºÔÚÿÌìµÄ0µã֮ǰ×Ô¶¯½«Êý¾Ý²åÈëÊý¾Ý¿â£¬Ï£Íû´ó¼ÒÖ¸µã£¡
×Ô¶¯²åÈë?Êý¾ÝÔ´ÄÄÀïÀ´µÄ,²åÈ뵽ʲôµØ·½
´¥·¢Æ÷?
Ó¦¸ÃÓÃJOB

Êý¾ÝÔ´ÔÝʱÏëµÄÊǹ̶¨Êý¾Ý£¬²åÈëµ½Ò»Õűí

ÄǾÍÊÇÓÃJOB¶¨Ê±Ö´ÐÐ,´ÓÎļþµ¼ÈëÊ ......

OracleÈÏÖ¤ - Oracle / ÈÏÖ¤Ó뿼ÊÔ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ