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

¶à¸öoracleÊý¾Ý¿âÖ®¼äÊý¾Ý¹²Ïí database link

ÒòΪ¹«Ë¾µÄÕÆÉϳÇÊÐϵͳÔÚ¶à¸öµØÊÆÍ¬Ê±ÉÏÏߣ¬¶øÎªÁËÈÃÿ¸ö³ÇÊеÄ3G¿ìѶ¾ßÓеØÊÆÌØÉ«ÐÔ£¬Ã¿¸öµØÊÆÓÐ×Ô¼ºµ¥¶ÀµÄÊý¾Ý¿âϵͳ£¬¶øÃ¿¸öµØÊƵĿìѶÓÖһЩ¹²Í¬µÄ£¬Æ©ÈçͻȻ³öÁËÒ»Ìõ¹ú¼ÊÐÂÎÅ£¬ÄÇôÊDz»ÊÇÿ¸öµØÊƵĺǫ́±à¼­¶¼ÒªÂ¼ÈëÒ»±é£¬ÕâÑùÎÞÒÉÊÇ×öÁËÐí¶àÎÞÓù¦£¬ËùÒÔ¹«Ë¾¿¼ÂǼÜÉèÒ»¸ö×ÜÕ¾£¬×ÜÕ¾ÉÏÓÐרÃŵÄÈ˸ºÔð£¬Ã¿Ì츺Ôð¼ÈëһЩͨÓõ쬲»¾ßÓеØÊÆÌØÉ«µÄÐÂÎÅ×ÊѶ£¬¶ø¸÷¸ö³ÇÊеÄÊý¾Ý¿â¶¼½«¹²Ïí×ÜÕ¾µÄÄÚÈÝ£¬Í¬Ê±ÓÖ¾ßÓб¾µØÌØÉ«µÄ×ÊѶ£¬Í¬Ê±½â·ÅÁËÈËÁ¦×ÊÔ´£¬¸÷¸ö³ÇÊпÉÒÔ¼¯ÖÐÓÚµØÊÆÌØÉ«µÄ½¨ÉèÉÏ¡£
ÕâÑùµÄ·½°¸£¬ÔÚ¼¼ÊõÉÏ£¬¾ÍÑݱä³ÉÁËÊý¾Ý¿âÖ®¼äµÄÊý¾Ý¹²Ïí£¬Ã¿µ±Â¼Èë×Üվ¼ÈëÊý¾ÝµÄʱºò£¬µ÷Óô¥·¢Æ÷£¬Í¨¹ýdatabaselinkÏòÆäËü¸÷¸ö·Öվͬ²½Êý¾Ý
Óõ½oracleµÄdatabase link,֮ǰҲû½Ó´¥¹ý£¬ÕâÁ½ÌìÒÀ¾Ý×ÊÁÏÃþË÷ÁËһϣ¬×ö¸ö¼Ç¼ÈçÏ£º
×÷ÓÃ:½«¶à¸öoracleÊý¾Ý¿âÂß¼­ÉÏ¿´³ÉÒ»¸öÊý¾Ý¿â,Ò²¾ÍÊÇ˵ÔÚÒ»¸öÊý¾Ý¿âÖпÉÒÔ²Ù×÷ÁíÒ»¸öÊý¾Ý¿âÖеĶÔÏó¡£
Óï·¨:
CREATE [PUBLIC] DATABASE LINK dblink CONNECT TO user IDENTIFIED BY password USING ‘connect_string’;
DROP [PUBLIC] DATABASE LINK dblink;
    ×¢Òâ:Äã±ØÐëÓÐCREATE DATABASE LINK»òCREATE PUBLIC DATABASE LINKµÄȨÏÞ£¨¿ÉÓÃsysÉí·ÝÈ¥·ÖÅ䣩,ÁíÍâ,ÔÚÄãÒªÁ¬½ÓµÄÊý¾Ý¿âÉÏ,µÄȨÏÞ.
²ÎÊý˵Ã÷:
    dblink: ÄãËù´´½¨µÄdatabase linkµÄÃû×Ö,
    userºÍpassword:ÒªÁ¬½ÓµÄÊý¾Ý¿âµÄÓû§ÃûºÍÃÜÂë
    connect_string:¿ÉÒÔÊǾ­¹ýNet ManagerÅäÖõÄ(tnsnames.ora)ÇÒ¾­²âÊÔ¿ÉÒÔÁ¬½ÓµÄ·þÎñÃû£¬²»¹ýÒ²¿Éд³ÉÕâÖÖÐÎʽ£¬¸üÖ±½Ó£º(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =orcl) )
ʹÓÃ:
select * from mobile_type@dblink ;
UPDATE mobile_type@dblink m set m.type_name='83-6' where m.type_id =6;
¾ßÌå²½Ö裺
1¡¢ Á´½Ó×Ö·û´®¼´·þÎñÃû£¬Ê×ÏÈÔÚ±¾µØÅäÖÃÒ»¸ö·þÎñÃû£¬µØÖ·Ö¸ÏòÔ¶³ÌµÄÊý¾Ý¿âµØÖ·,
µ±È»Ò²¿ÉÏòÏÂÃæÄÇÑùÖ±½ÓдµÄ¡£  
2¡¢´´½¨Êý¾Ý¿âÁ´½Ó£¨Ç°ÌáÊÇÒÑ·ÖÅäÏàӦȨÏÞ£©£¬½øÈëϵͳ¹ÜÀíÔ±SQL>²Ù×÷·ûÏ£¬ÔËÐÐÃüÁ
create database link wapsx
connect to WAP identified by wap
using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =


Ïà¹ØÎĵµ£º

Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó²éѯ±äÂýÎÊÌâ


Oracle ±íɾ³ý´óÁ¿Êý¾Ýºó£¬¼´Ê¹±íÖÐÖ»Óм¸ÐмǼ£¬µ«ÓÃselect count(*) from table À´²éѯ·¢¾õ¶¼²»»áÂíÉϳöÀ´£¬Ô­ÒòÊǸñíµÄ¿Õ¼ä´óÁË£¬²éѯÆðÀ´ºÜÂý¡£½â¾öµÄ·½·¨ÊǰѸñíËùÕ¼Óõıí¿Õ¼äËõС£¬»òÕß˵Êͷűí¿Õ¼ä¡£
alter table XXXX move; ÕâÑù´¦Àíºó¾ÍÊÍ·ÅÁ˱í¿Õ¼äÁË¡£µ«ÊÇÊͷűí¿Õ¼äºó£¬±íµÄÐкÅrowid»á·¢Éú±ä»¯£¬¶ø»ùÓÚ ......

oracleÆô¶¯ÎÊÌâÒ»°ã½â¾ö·½·¨

oracleÆô¶¯ÎÊÌâ
Ò»£ºÊý¾Ý¿âûÓÐÆô¶¯
#sqlplus /nolog
sql>connect /as sysdba
sql>startup
 
¶þ£º¼àÌý³öÎÊÌâ
µÇ¼DB·þÎñÆ÷
ʹÓÃlsnrctl start/stop¿ªÆô/¹Ø±Õ¼àÌý
ʹÓÃlsnrctl status²é¿´×´Ì¬
ÀíӦΪ£º
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ERPAP)(PORT=1521)))
STATUS of the ......

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer

²»Óð²×°Oracle ClientÈçºÎʹÓÃPLSQL Developer
1. ÏÂÔØoracleµÄ¿Í»§¶Ë³ÌÐò°ü£¨30M£©
      Ö»ÐèÒªÔÚOracleÏÂÔØÒ»¸ö½ÐInstant Client PackageµÄÈí¼þ¾Í¿ÉÒÔÁË£¬Õâ¸öÈí¼þ²»ÐèÒª°²×°£¬Ö»Òª½âѹ¾Í¿ÉÒÔÓÃÁË£¬ºÜ·½±ã£¬¾ÍËã֨װÁËϵͳ»¹ÊÇ¿ÉÒÔÓõġ£
      ÏÂÔØµ ......

OracleµÄÈÕÆÚº¯Êý

 
OracleµÄÈÕÆÚº¯Êý
 
 ³£ÓÃÈÕÆÚÐͺ¯Êý 
1¡£Sysdate µ±Ç°ÈÕÆÚºÍʱ¼ä
SQL> Select sysdate from dual;
SYSDATE
----------
21-6Ô -05
2¡£Last_day ±¾ÔÂ×îºóÒ»Ìì 
SQL> Select last_day(sysdate) from dual;
LAST_DAY(S ......

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ

Á¬½ÓOracleÊý¾Ý¿âµÄHibernateÅäÖÃÎļþ
Á¬½ÓOracleµÄHibernateÅäÖÃÎļþÓÐÁ½ÖÖ¸ñʽ£¬Ò»ÖÖÊÇxml¸ñʽµÄ£¬ÁíÒ»ÖÖÊÇJavaÊôÐÔÎļþ¸ñʽµÄ¡£ÏÂÃæ·Ö±ð¸ø³öÕâÁ½ÖÖ¸ñʽÅäÖÃÎļþµÄ´úÂë¡£
1£®xml¸ñʽµÄÅäÖÃÎļþ
ÏÂÃæ½«¸ø³öÁ¬½Ó±¾µØOracle·þÎñÆ÷ÉϵÄdb_database02Êý¾Ý¿âʱHibernateÅäÖÃÎļþhibernate.cfg.xmlµÄ´úÂë¡£
Àý³Ì2-5£º¹âÅÌ\mr ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ