ÈçºÎÔÚ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½Å±¾
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
ÎÒÒª¸ñʽ»¯Êý×Ö1£¬ÎÒµÄλÊýÊÇÒ»¸ö±äÁ¿n£¬ ÀýÈçn=3ʱ to_char(1,'FM099') ÎÒ²»ÖªµÀÔõôÓÃÄǸö±äÁ¿nÈ¥Ìæ»»ÄǼ¸¸ö9 û¿´¶® replaceô ÊǵÄÒýÓà û¿´¶® replaceô replace('FM099','9','ÏëÌæ»»³Éµ ......