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

Ë­ÄÜÍƼö¼¸±¾oracleµÄÊé»òÊÓƵ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½ÌµÄ»°

ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL

ûÓÐÌý˵¹ý°¡£¡



ÓÐûÓпª¹ýÕâ±¾ÊéµÄ£¬¸ø¸ö½¨Ò飿.. 3Q£¡~

ÒýÓÃ
ûÓÐÌý˵¹ý°¡£¡
ºÇºÇ ÎÒ˵µÄÄǾ仰¿ÉÄÜÓеãÆçÒå
ÖÐÎĵÄÊéÎÒ¿´¹ýµÄ´ó²¿·Ö¶¼ÊÇÄǸöORACLEPRESS³ö°æµÄ MCGRAWHILL 

¾ÍÊÇ˵ORACLEPRESS³ö°æµÄÊéÉÏÓ¡Á˸öMCGRAWHILLµÄLOGO
MCGRAWHILL²»ÊÇÊéÃû

oracle 10g Êý¾Ý¿â¹ÜÀíÓëÓ¦ÓÃϵͳ¿ª·¢ ÀîÏþÀè µÈ±àÖøµÄ£¬»ù±¾µÄ²Ù×÷»¹ÊDZȽÏÇåÎúµÄ£¬²»¹ýÊý¾Ý¿âµÄÊ鲻ͬµÄÊéÔÚ²»Í¬µÄ·½Ãæ²àÖز»Ò»Ñù £¬¶à¿´Ïà¹ØµÄ¼¸±¾¡£

ÊÓƵµÄ»°
С²¼ÀÏʦµÄORACLE½²µÄºÃÏñ»¹¿ÉÒÔ
Â¥Ö÷¿ÉÒÔÈ¥ËÑËÑ¿´¿´ 
ͦ¶àµÄ

UpµÈÍƼö~

Oracle_9i_DBA_Fundamentals

лл¡£Ð¡²¼ÀÏʦµÄÊÓƵ£¬¸ÕËÑÁËһϣ¬Óв»ÉÙ£¬»Ø¼ÒÏÂÔØ¡£


Ïà¹ØÎÊ´ð£º

ssh oracle Á¬½Ó


Ðֵܠ ͼ¹ÒÁË¡£

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......

ÊÇ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·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

ÇóÖúÒ»¸ö¶¨Ê±Ö´ÐÐoracle´æ´¢¹ý³ÌµÄÎÊÌ⣬Çë´óÏÀ°ïæ

ÎÒÐèÒªÓö¨Ê±Ö´Ðд洢¹ý³Ì£¬µ«ÊÇÎҵĴ洢¹ý³ÌÀïÓõ½µÄ±íÊÇÓÐÁ´½ÓµÄ£¬¾ÍÏñÕâÑù£º
.....from table_name@cxdb_link
Ò²¾ÍÊÇÎÒ½¨Á¢¶¨Ê±Æ÷µÄÊý¾Ý¿âÓë±íËùÔÚµÄÊý¾Ý¿â²»ÊÇÒ»¸ö¿â£¬£¨ÒòΪ±íËùÔÚµÄÊý¾Ý¿âÎÒûÓÐȨÏÞ½¨Á¢¶¨Ê ......

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

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