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

oracleÊý¾Ý¿âµÄÃû×ÖÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÔÚ´´½¨Êý¾Ý¿âµÄʱºòÓõÄÃû×ÖΪoracle10£¬µ«ÊÇ´´½¨ºÃºó£¬ÔÚĬÈϵÄĿ¼ÏÂÏÔʾµÄÃû³ÆÈ´ÊÇoracle10g£¬ÕâÊÇΪʲô£¿
Äã¿´µÄ 10gÊǰ²×°Ä¿Â¼°É 


SQL> select name from v$database;

NAME
---------
ORCL


ÒòΪÄã°ÑÎļþ¼Ð¿´´íÁ˰ɡ£

´ó¸ç£¬Èç¹û²»ÊÇÄãÑÛ»¨µÄ»°£¬ÄÇ¿ÉÄܾÍÊÇÄã½ø´íµØ·½ÁË¡£

ÓÃÈýÂ¥µÄ·½·¨²éһϾÍÖªµÀÊÇʲôÁË

ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£


ÕûÈËÓÐÒâ˼Â𣿡¡ÖªµÀ´ð°¸Ö±½Ó·¢ÉÏÀ´¹²Í¬Ñ§Ï°¡£¡¡Ñ§Ï°ÒªÇ«Ð飬¡¡Ã¿È˶¼ÓÐ×Ô¼ºµÄÓŵ㡣¡¡±ðÈËÈÈÐĵİïÄ㣬»¹³ö¿ÚÂîÈË£¬ÓÖ¼ûÒ»¸ö¸öÐÔµÄ90ºó£¬ ÕæÎÞÓïѽ.. ÒÔºó»¹ÏëÔÚÕâÀï»ì£¬×îºÃÇ«Ðéµã..

liuxinyu19901016


ÏȰÑÕâÌù¶¥ÆðÀ´£¬Èôó¼Ò¶¼ÈÏʶÈÏʶÄã.. liuxinyu19901016

¹þ¹þ 
90ºó¡­¡­

ʲô½ÐÖªµÀ´ð°¸£¬ÕâÊǺóÀ´Ñ§Ï°²éÕÒ¸ãÃ÷°×µÄ¡£Ê²Ã´½ÐÎÒÑÛ¾¦ÓÐÎÊÌ⣬²»ÖªµÀ¾ÍÊDz»ÖªµÀ»¹ÓýƱçÂð£¿ÎÞÓï¡£¡£¡£¡£¡£

ºÇºÇ
ºÍг ÂÛ̳ÐèÒªºÍг

1
¼´±ãÊÇÄãºóÀ´×Ô¼ºÍ¨¹ýѧϰ¸ãÃ÷°×ÁË Ò²ÒªÀ´ºÍ´ó¼Ò·ÖÏíÒ»ÏÂѽ ÔõôÄÜÖ»Îʲ»·ÖÏíÄØ ¶Ô²»¶Ô ÂÛ̳¾ÍÊÇÒ»¸ö´ó¼Ò»¥°ï»¥Öú¹²Ïí֪ʶµÄµØ·½

2
¼´±ãij¸öÈË˵´íÁË»° ÄãÒ²²»ÄÜ˵´ó¼Ò¶¼ÊÇÖí°É ºÇºÇ

ÒýÓÃ
ÄãÃǶ¼ÊÇһȺÖí£¬ÊÇӦΪoracle10Êǹؼü×Ö£¬ËùÒÔĬÈϵİÑoracle10±äΪoracle10gÁË¡£²»ÖªµÀ²»ÒªÂÒ·¢ÎÞÓõÄÌù¡£




Ïà¹ØÎÊ´ð£º

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

OracleÊý¾Ý¿âÔ½À´Ô½Âý¸ÃÈçºÎ´¦Àí£¿

Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

Âé·³¸ø¿´¿´Õâ¸öoracleÓï¾ä¸ÃÔõÑùд

±íÃû£ºgk_record_new£¨ÕâÊÇÒ»¸ö¿¼ÇÚ±í£¬ËùÓÐÔ±¹¤µÄ¿¼ÇÚÊý¾Ý¶¼´æ·ÅÔÚÕâ¸ö±íÀÖ÷¼üΪ¿¨ºÅºÍʱ¼ä£©
±í½á¹¹£º
¿¨ºÅ£ºNUMBER(10)
»ùÕ¾£ºVARCHAR2(20)
ʱ¼ä£ºDATE
³öÈë±êÖ¾£ºVARCHAR2(1)
±íÊý¾Ý
¿¨ºÅ »ùÕ¾ ʱ¼ä ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ