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

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ÓÅÊÆÊÇʲô£¿

ÒýÓÃ
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µÄ£¬¿ÉÒÔÏÂÔØ¿ÉÒÔ°²×°¿ÉÒÔʹÓá£

¿ÉÒÔ¡£¡£ÐèÒªÏÂÔØÏàÓ¦µÄ²Ù×÷ϵͳϵÄÊý¾Ý¿â°æ±¾¡£¡£

ËäȻûÓÐÂúÒâµÄ´ð°¸£¬¸Ðл´ó¼ÒµÄ»Ø¸´£¬
Óлظ´£¬¾Í»áµÃ·Ö


Ïà¹ØÎÊ´ð£º

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

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

oracle ×Ô¶¨Òå·Ö×é - Oracle / »ù´¡ºÍ¹ÜÀí

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 ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ