Çë½Ì¹ØÓÚoracleÊý¾Ýµ¼³öµÄÎÊÌâ?
ÎÒÏÖÔÚÊý¾Ý¿âÖÐÓÐÁ½¸öÓû§£¬Ã¿¸öÓû§´óÔ¼ÓÐ50¸ö±í£¬ÏÖÔÚÒªÒÔÓû§Îªµ¥Î»°Ñ50¸ö±íµÄ½á¹¹µ¼³ö³ÉEXCEL¸ñʽÖУ¬ÒÔ¼°Ã¿¸ö±íµÄǰ100¸öÊý¾Ýµ¼³öµ½EXCELÖУ¬Çë½ÌÓÐûÓкõÄЧÂʸߵİ취£¬ÏÖÔÚÒѾװÁËPL/SQL DEVÁË£¬ÇëÇó°ïÖú£¡
Â¥Ö÷ºÃÏñÊÇÒªExcel¸ñʽµÄ£¬²»»áÕâÖÖ·½·¨£¬Ö»ÄÜÊǰﶥÁË¡¡ ×Ô¼ºÐ´PL/SQLÀ´µ¼³ö°É µ«ÊÇûÓÐÅúÁ¿µ¼³öexcelµÄ¹¦ÄÜ£¬ÕâµãÂú×ã²»ÁËÂ¥Ö÷µÄÐèÇó¡£ Ã»ÓÐÁË¡£Ö»ÄÜÒ»ÕÅÕÅ±íµ¼ ¿´ÄãµÄÐèÇóÖ»ÄÜд³ÌÐòµ¼ÁË¡£ д³ÌÐò°ÉÒýÓà Äã¿ÉÒÔÔÚpl/sql devµÄsql windowÖÐд³ö²éѯÓï¾äselect * from tab where rownum <=100,°´F8Ö´Ðкó£¬Ñ¡Öвéѯ³öÀ´µÄ£¬ÔÙµãÓÒ¼ü£¬Ñ¡Ôñ¡°copy to excel¡±¼´¿ÉʵÏÖµ¼³öµ½excel¡£ Èç¹ûÄ㲻ϣÍûÓÐÊý¾Ýµ¼³öµ½excel,¿ÉÒÔ½«sql ¸ÄÔì³ÉÈçÏ£ºselect * from tab where 1>2 ÔÞͬ£¬Â¥Ö÷ÏëÒªÅúÁ¿²Ù×÷µÃÁíÏë°ì·¨¡£ Ò»ÕÅÒ»ÕŵĸãÁË£¬ÅúÁ¿ÔÝʱûÏë³öÀ´ÓÃʲô·½·¨
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
select sum£¨a.t)from ta a group by ta.a,ÕâÌõÓï¾ä½«±ítaÖеÄÊý¾Ý°´ÕÕa×ֶηÖ×é»ã×Üt×ֶΡ£ ½á¹û±ÈÈ磺 3 30 4 50 ÎÒÏëµÃµ½Õâ¸ö½á¹û£º 1 0 2 0 3 30 4 50 5 0 Õâ¸ö½á¹û£¬ÇëÎÊsqlÓï¾äÔõôд£¿¶àл nobody ......
eclipse 3.3Æô¶¯web¹¤³Ì£¬ÒªÁ¬½Óoracle9iÊý¾Ý¿â±¨ ÑÏÖØ: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off cli ......