Oracle Database 11g(11.2.0.1.0)µÚ2°æ
¿ÉÒÔÔÚ£ºxp¡¢windows2008ϰ²×°Âð£¿
Èô¿ÉÒÔ£¬ÔÚÄÇÀïÓÐÏÂÔØ£¿
лÁË
http://www.oracle.com/technology/software/products/database/index.html
ÔÝδÌṩwindowsƽ̨°æ±¾¡£
ÎÞÏÞ¾«²Ê£¬ÖµµÃÆÚ´ý£¡
×°LINUX
ԽѧԽӦ¸ÃѧϰLINUX»òÕßUNIXϲÙ×÷
windowsƽ̨,ÊÇ·ñÒÔºó£¬ÓпÉÒÔÌṩ£¿
LINUX¶¼Ã»ÓÐÓùý£¬²»ÖªµÀÔõôÓÃ
Ó¦¸Ã»áÌṩµÄ£¬Ã»Ìý˵ORACLE×¼±¸²»·¢ÐÐwindows°æ±¾µÄ¡£Ö»²»¹ýwindows°æ±¾Ì«¶à£¬¸üп졣»¹ÓУ¬´óÐÍÓ¦ÓÃÔÚwinÉÏÃæµÄ±È½ÏÉÙ°É¡£
oracleÔÚLINUXºÍwindowsÉÏÃæ£¬
ÄǸö±È½Ï¿ìÄØ£¿
LINUXÓÅÊÆÊÇʲô£¿
¿É¶¨ÖÆ¡¢°²È«ÐÔ¡¢¿É¿¿ÐÔ£¬ÕâÊÇÒµ½çÑ¡ÔñUNIX£¨»òÕßÀàUNIX£©µÄÀíÓÉ¡£
Èç¹û·þÎñÆ÷ºÍÍâÍøÁ¬½ÓÔÚÒ»Æð£¬Ñ¡ÔñLINUXÊÇ×îºÃµÄ£»
ÈôÊDZ¾µØÍøÂ磬ѡÔñWINDOWSºÃÏñ±È½ÏºÃʹÓÃ
oracle ¹Ù·½ÏÂÔØµØÖ·£¬ÕâÀïûÓоÍÊÇûÓÐÁË¡£¡£¡£
http://www.oracle.com/technology/software/products/database/index.html
¸üÐÂÕæ¿ì
ORACLE¹Ù·½ÍøÕ¾¾ÍÓÐÏÂÔØ¡£ÓÐFOR WINDOWS°æ±¾µÄºÍFOR LINUX°æ±¾Á½ÖÖ¡£ÎÒ¾ÍÊÇXPµÄ£¬¿ÉÒÔÏÂÔØ¿ÉÒÔ°²×°¿ÉÒÔʹÓá£
¿ÉÒÔ¡£¡£ÐèÒªÏÂÔØÏàÓ¦µÄ²Ù×÷ϵͳϵÄÊý¾Ý¿â°æ±¾¡£¡£
ËäȻûÓÐÂúÒâµÄ´ð°¸£¬¸Ðл´ó¼ÒµÄ»Ø¸´£¬
Óлظ´£¬¾Í»áµÃ·Ö
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£
½á¹û±ÈÈ磺
3 30
4 50
ÎÒÏëµÃµ½Õâ¸ö½á¹û£º
1 0
2 0
3 30
4 50
5 0
Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл
nobody ......
ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
declare
TYPE test_rec IS record(
code varchar(10),
name varchar(30)
);
v_book test_rec;
......