asp.net c# ÏëÒªµ÷ÓÃoracle spoolµ¼³öÎļþ
ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾ ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐÐ ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä Ϊʲô Ôõô°ì £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ £¿ »¹Êǵôò¿ªsql/plus°¡ ÇóÖú
.net²»¶® Ö»ÄܰﶥÁË¡£¡£¡£ ¶¥................ 5555 ÎÒÊÔÊÔ´æ´¢¹ý³Ì »¹ÓбðµÄ·½·¨Â𣿠ÓÐÈËÖªµÀÔõôµ÷Óýű¾Âð UPVVVVVVVVVVVVVVVVVVVVVVVVVVÒýÓà ÎÒÏëÔÚwebÖÐ ÓÃspool ´ÓoracleÖе¼³ö exel±í¸ñ ´úÂëдºÃÁË ´æÔڽű¾ µ«²»»áµ÷Óýű¾ ÓÃÁ˸ö±¿·½·¨ oraclecommend a=£¨¡° set colsep' '¡±£¬conn£© Ò»ÌõÒ»ÌõÖ´ÐÐ ÓÃsql/plusÔËÐнű¾Ã»ÎÊÌ⣬µ«ÊÇÔÚÍøÒ³Öв»Ê¶±ðÎÒдµÄÓï¾ä Ϊʲô Ôõô°ì £¿ ÊDz»ÊÇÎÒµÃÔÙÌî¼Óij¸öÍ·Îļþ £¿ »¹Êǵôò¿ªsql/plus°¡ ÇóÖú oraclecommend ÒýÓà ½¨Ò飺²»Ê¹Óà spool (1) ÏȽ«Êý¾Ý´Ó Oracle Öвéѯ³öÀ´£¬´æÈë DataSet (2) ÔÙ½«Êý¾Ý´Ó DataSet µ¼³öΪ Excel£¬·½·¨ºÜ¶à£¬´óÖÁ·ÖΪÈýÀࣺ i. HTML table ÐÎʽ»ò csv¸ñʽ µÄ αExcel ²Î¿¼´úÂë http://www.cnblogs.com/evernory/archive/2004/09/22/45580.html http://www.cnblogs.com/freeliver54/archive/2009/02/23/1396373.html ii.µ÷ÓÃExcelµÄCOM×é¼þµ¼³öÕæExcelÎļþ£¨È±ÏÝ£º·þÎñÆ÷¶Ë±ØÐë°²×° MS Office¡¢Íê
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
txt ºÍXML ¸ñʽÏàÓ¦ ²»½èÖúDataSet µ¼Èë¶ÁÈ¡TXTÎļþ È»ºóÖ±½ÓдÈëXML(ͬһÎļþ,²»Í¬Êý¾Ý,µÝÔöÔÊý¾ÝûÓб»¸²¸ÇÇé¿öÏÂÔö¼ÓÊý¾Ý.) ½Ì¸öÒªµã»ò×îºÃÊÇÓиö´úÂëÌáʾµÄ ¹ý·ºÃºº °ï¸öæÈö^^ ²»»á£¬°ïÂ¥Ö÷ ......
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......