å¦ä½ä½¿ç¨PLSQL Developerä»oracleæ°æ®åº 导å
¥å¯¼åºæ°æ®
ç¨pl/sql developer导åºè¡¨çæ°æ®æ¶æä¸ç§æ¹å¼ï¼Oracle Exportï¼Sql Insertï¼pl/sql developer
åªæâOracle Exportâæ¹å¼å¯¼åºå导å
¥åï¼è¡¨ç»æåç´¢å¼ç»æ没æåçååï¼å¦ä¸¤ç§æ¹å¼é½æ¹åäºç´¢å¼ç±»åãå¦å¤
Sql Insertçé£ä¸ªå¯ä»¥å¯¼æsqlï¼å¯ä»¥ç¨ææ¬ç¼è¾å¨æå¼ã
pl/sql developer ä¹å¯ä»¥å¯¼åºï¼ä½ææ¬ç¼è¾å¨ä¸è½æå¼ã
åºå«ï¼
Oracle Exportï¼Sql Insertï¼pl/sql developer
第ä¸ç§æ¯å¯¼åºä¸º.dmpçæä»¶æ ¼å¼ï¼.dmpæ件æ¯äºè¿å¶çï¼å¯ä»¥è·¨å¹³å°ï¼è¿è½å
å«æéï¼æçä¹å¾ä¸éï¼ç¨å¾æ广
第äºç§æ¯å¯¼åºä¸º.sqlæ件çï¼å¯ç¨ææ¬ç¼è¾å¨æ¥çï¼éç¨æ§æ¯è¾å¥½ï¼ä½æçä¸å¦ç¬¬ä¸ç§ï¼éåå°æ°æ®é导å
¥å¯¼åºãå°¤å
¶æ³¨æçæ¯è¡¨ä¸ä¸è½æ大å段ï¼blob,clob,longï¼ï¼å¦ææï¼ä¼æ示ä¸è½å¯¼åº(æ示å¦ä¸ï¼
table contains one or more LONG columns cannot export in sql format,user Pl/sql developer format instead)ï¼å¯ä»¥ç¨ç¬¬ä¸ç§å第ä¸ç§æ¹å¼å¯¼åºã
第ä¸ç§æ¯å¯¼åºä¸º.pdeæ ¼å¼çï¼.pde为Pl/sql developerèªæçæä»¶æ ¼å¼ï¼åªè½ç¨Pl/sql developerèªå·±å¯¼å
¥å¯¼åºï¼ä¸è½ç¨ç¼è¾å¨æ¥çï¼
导åºæ°æ®å°excelæ件ï¼
éä¸æ°æ®è¡¨--query data--éä¸è¦å¯¼åºçæ°æ®--å³é®copy to excel
excelæ°æ®å¯¼å
¥å°æ°æ®åºï¼
1.å¨Excelä¸åå¤å¥½è¦å¯¼å
¥çæ°æ®ãå
·ä½æä½ï¼å¨Excelä¸ï¼æ第ä¸å设置为空åï¼ç¬¬äºå以åçååºä¸è¦å¯¼å
¥çæ°æ®è¡¨çå段ç¸å¯¹åºã
2.ç»å½PLSQL Developerï¼æ¾å°éè¦å¯¼å
¥æ°æ®çæ°æ®åºè¡¨åï¼ç¹å»å³é®--edit dataï¼è¿å
¥äºç¼è¾æ¤è¡¨çæ°æ®å¯¹è¯æ¡ï¼å¹¶ç¹å»æ左侧éä¸ä¸ç©ºè¡ã
3.copy Excel表ä¸çæ°æ®è®°å½ï¼å°æ°æ®ç²è´´å°ä¸æ¥ä¸PLSQL Developeræ¾ç¤ºç表åä¸ã
4.ç¹å»PLSQL Developerä¸ç对å·æé®è¿è¡Postã
注æï¼PLSQL Developerä¸è®¤è¯â-â
温馨提示:答案为网友推荐,仅供参考