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

½«Îı¾Îļþµ¼Èëµ½OracleµÄÎÊÌâ

1.ÇëÎÊÈçºÎͨ¹ýsqlÓï¾ä½«Îı¾Îļþµ¼Èëµ½OracleÖÐÄØ

2.ÇëÎÊÐèÒªµ¼Èëµ½OracleÖеÄÎı¾ÎļþÖеĸñʽӦ¸ÃÊÇÔõÑùµÄ£¿
Àý£º¼ÙÉèÎÒÏë°ÑÒ»°ÙÍòÌõÊý¾Ý´ÓÎı¾Îļþµ¼Èëµ½±íAÖР AÓÐÈý¸ö×ֶΠ AID  AName  ADate  Èý¸ö²»Í¬ÀàÐÍ
    ÇëÎÊÎÒÕâÒ»°ÙÍòÌõÊý¾ÝÓ¦¸ÃÒÔʲô¸ñʽ´æÈëµ½txtÎļþÖвÅÄܵ¼Èëµ½±íAÄØ

3.ÇëÎÊOracleÔÚµ¼ÈëÎļþµÄʱºò¼ÓµÄÊÇÄÄÖÖËø£¬Èç¹ûµ¼ÈëµÄʱºòÎÒÕýÇÉÔÚ²éѯ¸Ã±íA£¬»á³öÏÖʲôÇé¿ö


µ¼ÈëÎı¾Îļþ  ÓÃsqlldr

1  ´¿SQLÓï¾äÎÞ·¨ÊµÏÖ£¬¿ÉÒÔʹÓÃsql*loader
2  ORACLE¶ÔÄãµÄÎı¾Êý¾Ý¸ñʽÎÞÒªÇó£¬Ö»ÒªÄãµÄʵ¼ÊÊý¾ÝÓëÄã±í×Ö¶ÎÀàÐͲ»³åÍ»¡£
3  ORACLE¶ÁÓëд²»³åÍ»¡£µ¼Èëʱ²éѯ±íA£¬²é³öµÄÊÇÔ­ÓÐÊý¾Ý+Äãµ¼ÈëÒÑÌá½»Êý¾Ý¡£

ÒýÓÃ
2  ORACLE¶ÔÄãµÄÎı¾Êý¾Ý¸ñʽÎÞÒªÇó£¬Ö»ÒªÄãµÄʵ¼ÊÊý¾ÝÓëÄã±í×Ö¶ÎÀàÐͲ»³åÍ»¡£
3  ORACLE¶ÁÓëд²»³åÍ»¡£µ¼Èëʱ²éѯ±íA£¬²é³öµÄÊÇÔ­ÓÐÊý¾Ý+Äãµ¼ÈëÒÑÌá½»Êý¾Ý¡£


2.¶Ô¸ñʽÎÞÒªÇóÊÇʲôÒâ˼£¬¼ÙÈçÎÒÓÐÈý¸ö×ֶΣ¬ÎÒÔÚTXTÎļþÖÐÔõô¼ÓÈë·Ö¸ô·û£¬»»Ðзû¡£ËùÓеÄÊý¾Ý¶¼Ð´ÔÚÒ»Æð¿Ï¶¨Ã»°ì·¨Çø·ÖÊÇÄǸö×ֶεİ¡£¿
3.ÎÒÔÚµ¼Èë±íAµÄʱºò²»»á×Ô¶¯Ëø±íÂð£¿ÕâÊÇÈç¹ûÕýÔÚÖ´Ðвéѯ£¬Ëø±í¾Í»áʧ°ÜµÄ°É£¿


2  ÊÇÐèÒªÓÐͳһ·Ö¸î·û¡£

3  Õâ¸ö²»ÐèÒªÄ㿼ÂÇ£¬ÄãÖ»ÐèÒª¼Çס£¬<span style="font-size:24px">ORACLEд²»×èÈû¶Á£¬·´Ö®ÒàÈ»</span>¡£

ÓÐûÓпÉÒÔͨ¹ý³ÌÐòÖ±½ÓÓÃÓï¾äÀ´Íê³ÉµÄ·½·¨ÄØ

ÓÃsql loader
ÓÃÍⲿ±íÒ²ÐÐ

sqlldrÊÇͨ¹ýÃüÁîÐÐÀ´Ö´Ðеģ¬Ò²¾ÍÊÇ˵ÿ´ÎÔËÐÐsql


Ïà¹ØÎÊ´ð£º

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

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

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

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ