Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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½Å±¾


Ïà¹ØÎÊ´ð£º

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

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 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

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

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

XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ