尊龙凯时人生就是搏

oracleÔõôµ¼³ödbfÎļþ

ʹÓà oracle sql*plus£¬¿ÉÒÔͨ¹ýÒÔÏ°취½« oracle ±íµ¼³öΪ dbf Îļþ£ºÅþÁ¬µ½Êý¾Ý¿â£»Ê¹Óà select into outfile Óï¾äµ¼³ö±í£»×Ô½ç˵µ¼³öµÄ dbf ÃûÌÃÑ¡Ï¿ÉÑ¡£©£»Ö´Ðе¼³öÓï¾ä£»¼ì²éÊä³ö¡£

Oracle µ¼³ö DBF Îļþ

ÔõÑùµ¼³ö DBF Îļþ£¿

ʹÓà Oracle SQL*Plus ÊÊÓóÌÐò£¬¿ÉÒÔÇáËɵؽ« Oracle ±íÖеÄÊý¾Ýµ¼³öΪ DBF Îļþ¡£

Ïêϸ°ì·¨£º

1. ÅþÁ¬µ½Êý¾Ý¿â

ÔÚ SQL*Plus ÖУ¬Ê¹ÓÃÒÔÏÂÏÂÁîÅþÁ¬µ½ Oracle Êý¾Ý¿â£º

connect username/password@database_name

µÇ¼ºó¸´ÖÆ

2. µ¼³ö±í

Òª½«±íµ¼³öΪ DBF Îļþ£¬ÇëʹÓà SELECT INTO OUTFILE Óï¾ä¡£ÆäÓï·¨ÈçÏ£º

SELECT *
INTO OUTFILE 'file_path.dbf'
FROM table_name;

µÇ¼ºó¸´ÖÆ

Ìæ»» file_path.dbf ΪĿµÄ DBF ÎļþµÄ·¾¶ºÍÎļþÃû¡£

3. ÉèÖà DBF ÃûÌÃÑ¡Ï¿ÉÑ¡£©

Äú¿ÉÒÔͨ¹ýÒÔÏÂÑ¡ÏîÀ´×Ô½ç˵µ¼³öµÄ DBF Îļþ£º

FIELDS TERMINATED BY£ºÖ¸¶¨ÍÑÀë×ֶεÄ×Ö·û¡£

OPTIONALLY ENCLOSED BY£ºÀ§ÈÆÎı¾×ֶεÄ×Ö·û£¨¿ÉÑ¡£©¡£

LINES TERMINATED BY£ºÖ¸¶¨ÍÑÀëÐеÄ×Ö·û¡£

4. Ö´Ðе¼³öÓï¾ä

Ö´ÐÐ SELECT INTO OUTFILE Óï¾äÒÔµ¼³ö±íÊý¾Ýµ½ DBF Îļþ¡£

5. ¼ì²éÊä³ö

Àֳɵ¼³öºó£¬Oracle ½«ÌìÉúÒ»ÌõÐÂÎÅ£¬ÈçÏÂËùʾ£º

1 row exported

µÇ¼ºó¸´ÖÆ

ʾÀý£º

½« customers ±íµ¼³öΪÃûΪ customers.dbf µÄ DBF Îļþ£º

SELECT *
INTO OUTFILE 'c:\temp\customers.dbf'
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
FROM customers;

µÇ¼ºó¸´ÖÆ

×¢ÖØÊÂÏ

Ä¿µÄ DBF Îļþ±ØÐè¾ßÓÐÊʵ±µÄȨÏÞ£¬ÔÊÐíдÈë¡£

µ¼³öµÄ DBF ÎļþµÄ×Ö¶ÎÃûÓë Oracle ±íÖеÄ×Ö¶ÎÃûÏàͬ¡£

µ¼³öµÄ DBF ÎļþµÄ¼Í¼˳ÐòÓë Oracle ±íÖеÄ˳ÐòÒ»Ö¡£

ÒÔÉϾÍÊÇoracleÔõôµ¼³ödbfÎļþµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是搏ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是搏ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是搏

18523999891

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ