Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÔÚ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½Å±¾


Ïà¹ØÎÊ´ð£º

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......

javaÁ¬²»ÉÏoracle£¿ - Java / Java EE

java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ