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

sqlserverºÍoracleÈçºÎ×öÊý¾Ý¿âͬ²½

ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£

Ìõ¼þ£º
oracle9i;sqlserver2000;

òËƲ»´ó¿ÉÄÜ

¾Í±»ÅÐËÀÐÌÁË£¿£¿


×ö¸öJOB

ÒýÓÃ
ÒýÓÃÂ¥Ö÷ stonec µÄ»Ø¸´:
ÒªÇó£º
1£©½«Ò»Ì¨oracleÖ÷Êý¾Ý¿âµÄÊý¾ÝÖеÄijЩ±íͬ²½¸üе½¶ą̀sqlserver·þÎñÆ÷É϶ÔÓ¦±íÖУ»
2£©×îºÃÄÜʱʵͬ²½£¬Èç¹û²»ÄÜʱʵ£¬¶¨Ê±Í¬²½Ò²¿ÉÒÔ¡£
3£©×îºÃ²»ÒÀÀµ³ÌÐò×öͬ²½¸üУ¬µ¥´¿Í¨¹ýÊý¾Ý¿â×ÔÉíʵÏÖ¡£

Ìõ¼þ£º
oracle9i;sqlserver2000;


Èç¹û·ÇÒªÕâÁ½¸ö¿âͬ²½,
1.ʹÓóÌÐòÀûÓÃtimer¶¨Ê±Æ÷´ÓÒ»¸ö¿â»ñÈ¡Êý¾Ý¸üе½ÁíÍâÒ»¸ö¿â.
2.ʹÓô¥·¢Æ÷,Ò»µ©Êý¾Ý·¢Éú¸üÐÂ,²åÈëµÈ¾ÍÁ¢¼´¸üе½ÁíÍâÒ»¸ö¿â.
SQL codeÔÚSQL SERVER 20000ÖзÃÎÊOracleÊý¾Ý¿â·þÎñÆ÷µÄ¼¸ÖÖ·½·¨1.ͨ¹ýÐм¯º¯Êýopendatasource
ÒªÇó:±¾µØ°²×°Oracle¿Í»§¶Ëselect*fromopendatasource('MSDAORA','Data Source=XST4;User ID=manager;Password=sjpsjsjs')..MISD.PBCATCOL
ÆäÖУ¬MSDAORAÊÇOLEDBFOR OracleµÄÇý¶¯£¬

×¢Òâ:Óû§ÃûºÍ±íÃûÒ»¶¨Òª´óС£¬·þÎñÆ÷ºÍÓû§ÃûÖ®¼äÊÇÁ½¸öµã£»
ÀýÈç:selecttop10*fromopendatasource('MSDAORA','Data Source=HZTEST;User ID=osstest;Password=a1234')..OSSTEST.SUBSCRIBER

±¾µØOracle¿Í»§¶ËÅäÖÃÎļþÖÐÄÚÈÝÈçÏÂ:
HZTEST=
  (DESCRIPTION=
    (ADD


Ïà¹ØÎÊ´ð£º

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

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

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

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

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

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

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

¶à±í¹ØÁª²éѯµÄ sqlд·¨ - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ£¬ÎÒ×î½üά»¤Ò»¸öÏîÄ¿£¬100¶à¸ö±í
Ö»ÄÜÓÃjdbcÖ±Á¬
Óöµ½Á˶à¸ö±í ¹ØÁª ²éѯµÄÇé¿ö Çë´ó¼ÒÖ¸½Ì
±ÈÈç
student(studentid,classid)
class(classid,classname)
class_teacher(classid,teacherid)Õâ¸öÊÇÖмä±í ......

oracle ÊÔͼÎÊÌ⣬Çë¸ßÊÖ°ï棬ÔÚÏßµÈ.....

ÎÊÌâÃèÊö£º
1¡¢¼ÙÉèÓбí
t1±í£¬°üº¬ËÄÁÐ
 s1 a b c
 1 a a a
 2 b b b 
.........
t2±í£¬°üº¬2ÁÐ
s2 ff
1 77
2 88
............
ÈçºÎÉú³ÉÕâÑùµÄºÏ²¢Ê ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ