ÈçºÎÔÚoracle²éѯºóÉú³ÉÎı¾Îļþ - Oracle / ¿ª·¢
Ò»¸ö²éѯ֮ºóÔõô¿ÉÒÔÉú³ÉÒ»¸öÎı¾Îļþ°¡? Ìý˵ÓÃshell½Å±¾¿ÉÒÔ×öµ½£¿ÄÇÒªÔõô×öÄØ£¿
spool D:\test.xls select name,value from table_name; spool off Êǽ«Êä³ö½á¹ûÊä³öΪÎı¾£¬»¹Êǽ«²éѯÓï¾äÊä³öΪÎı¾¡£ ÎÒÖ»ÏëÒª½á¹û ¿ÉÒÔspool³öÀ´»¹ÓÐÁÐÃûµÄÆäËû¶«Î÷ SQL code: ID PPP_BEGINTIME ROAMFLAG PAIDTYPE --------- ------------- -------- -------- 242489576 2010-04-19 23 2 1 242489577 2010-04-20 00 2 1 99 rows selected ÎÒÏëÒªµÄ½á¹ûÊÇÕâÑùµÄ SQL code: 242489576|2010-04-19|23|2|1 242489577|2010-04-20|00|2|1 End_rbody_64881934//--> ¸Ã»Ø¸´ÓÚ2010-04-22 12:58:08±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP ussl2alsk2 (ussl2alsk2) µÈ¡¡¼¶£º #7Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-22 12:29:05 End_rbody_64884134//--> ¸Ã»Ø¸´ÓÚ2010-04-22 13:21:22±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓà ¾Ù±¨ ¹ÜÀí TOP hxj1225 µÈ¡¡¼¶£º #9Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2010-04-22 16:27:19 ÒýÓà һ¸ö²éѯ֮ºóÔõô¿ÉÒÔÉú³ÉÒ»¸öÎı¾Îļþ°¡? Ìý˵ÓÃshell½Å±¾
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ »·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ. XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿ ¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......