Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

oracleÈÕÆÚ·Ö¶Î

ÓÐÒ»±í´æ´¢ÄÚÈÝΪ£º
t_date          t_bl
2007-02-18      1.5%
2007-03-05      1.8%
2007-03-22      2.0%
2007-04-15      3.0%
2007-05-20      2.0%
2007-06-07    &nbs ......

¹ØÓÚOracle ½Ì³Ì

ÄÇλÓÐOracle 10g µÄÊÓÆµ½Ì³Ì°¡,¹²Ïíһϣ¬Ð»Ð»ÁË


ÍøÉÏÓÐС²¼ÀÏʦµÄOracle ÊÓÆµ½Ì³Ì. ¾Ý˵²»´í.
ÎÒ»¹ÊDZȽÏϲ»¶¿´Êé..


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.d ......

ÇóÒ»ORACLE Óï¾ä~~

ÏÖÓÐ2ÕÅ±í  A B
A±íºÍB±íÓй²Í¬×Ö¶ÎLINK

A±íÊÇͳ¼ÆÊýÁ¿µÄ
B±íÊÇͳ¼Æ¼Û¸ñµÄ

µ¥¶ÀµÄʱºòÕâÑùÏÔʾ ÀýÈç
A±í
  LINK    NUM
  XX    100

B±í
  LINK    NUM2
  XX    1000
ÎÒÏëͨ¹ý ͨ¹ýGROUP BY LINK&nbs ......

ÍÆ¼ö¼¸±¾oracleºÃÊ飬²»Å¹ó

ÖÐÎİæµÄ£¬Ð»Ð»
ÆðÂëҪ˵ÊÇ¿ª·¢»¹ÊǹÜÀíµÄ°É£¿

ÒýÓÃ
ÆðÂëҪ˵ÊÇ¿ª·¢»¹ÊǹÜÀíµÄ°É£¿

ÏÈÂò¿ª·¢°É£¬¸ßÊÖ¸øÍƼö¼¸±¾£¬·Ç³£¸Ðл

Ê×ÍÆÕâ±¾ÁË£º¡¶Oracle9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡·
ÍøÉÏÓÐÖÐÎİæµÄpdf£¬²»¹ýÓÐһЩoracleµÄ¿ª·¢ºÍµ×²ãÔ­Àí»ù´¡£¬¿´ÆðÀ´Ð§¹û»áºÃЩ¡£
ÕâÊé²»»á¸æËßÄãÄÇЩ»ù´¡Óï·¨Ôõà ......

Ò»¸öoracleÊý¾Ý¿âÆô¶¯µÄÎÊÌâ

oracle °æ±¾Îª10g
²Ù×÷ϵͳΪwindows xp
ƽʱֻҪÆô¶¯ÁËÊý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐòºó
ÔÚdosÃüÁîÆ½Ì¨ÊäÈëSQLPLU USER/PWD@SID¾Í¿ÉÒÔÁ¬½Óµ½ÏàÓ¦µÄÊý¾Ý¿â
µ«ÊÇ£¬½ñÌì³öÏÖÁËÒ»¸öÎÊÌ⣺
ÎÊÌâ²úÉú²½ÖèÈçÏ£º
1¡¢Æô¶¯Êý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐò
2¡¢sqlplus sys/pwd@sid as sysdbaÒÔ¹ÜÀíÔ±½øÈë
3¡¢shutdown¹Ø±ÕÊý¾Ý¿â ......

ÈçºÎȡһ¸ö±íµÄ·Ö×éÖÐʱ¼ä×îÍíµÄÒ»Ìõ¼Ç¼£¿(oracle)

»·¾³£ºoracle 9i
±íÃû£ºtable

name                        time

mike                        20100209-00:10:01:123
mike            ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [1351] [1352] [1353] [1354] 1355 [1356] [1357] [1358] [1359] [1360]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ