ÓÐÒ»±í´æ´¢ÄÚÈÝΪ£º
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 10g µÄÊÓÆµ½Ì³Ì°¡,¹²Ïíһϣ¬Ð»Ð»ÁË
ÍøÉÏÓÐС²¼ÀÏʦµÄOracle ÊÓÆµ½Ì³Ì. ¾Ý˵²»´í.
ÎÒ»¹ÊDZȽÏϲ»¶¿´Êé..
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.d ......
ÏÖÓÐ2Õűí A B
A±íºÍB±íÓй²Í¬×Ö¶ÎLINK
A±íÊÇͳ¼ÆÊýÁ¿µÄ
B±íÊÇͳ¼Æ¼Û¸ñµÄ
µ¥¶ÀµÄʱºòÕâÑùÏÔʾ ÀýÈç
A±í
LINK NUM
XX 100
B±í
LINK NUM2
XX 1000
ÎÒÏëͨ¹ý ͨ¹ýGROUP BY LINK&nbs ......
ÖÐÎİæµÄ£¬Ð»Ð»
ÆðÂëҪ˵ÊÇ¿ª·¢»¹ÊǹÜÀíµÄ°É£¿
ÒýÓÃ
ÆðÂëҪ˵ÊÇ¿ª·¢»¹ÊǹÜÀíµÄ°É£¿
ÏÈÂò¿ª·¢°É£¬¸ßÊÖ¸øÍƼö¼¸±¾£¬·Ç³£¸Ðл
Ê×ÍÆÕâ±¾ÁË£º¡¶Oracle9i&10g±à³ÌÒÕÊõ£ºÉîÈëÊý¾Ý¿âÌåϵ½á¹¹¡·
ÍøÉÏÓÐÖÐÎİæµÄpdf£¬²»¹ýÓÐһЩoracleµÄ¿ª·¢ºÍµ×²ãÔÀí»ù´¡£¬¿´ÆðÀ´Ð§¹û»áºÃЩ¡£
ÕâÊé²»»á¸æËßÄãÄÇЩ»ù´¡Óï·¨Ôõà ......
oracle °æ±¾Îª10g
²Ù×÷ϵͳΪwindows xp
ƽʱֻҪÆô¶¯ÁËÊý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐòºó
ÔÚdosÃüÁîÆ½Ì¨ÊäÈëSQLPLU USER/PWD@SID¾Í¿ÉÒÔÁ¬½Óµ½ÏàÓ¦µÄÊý¾Ý¿â
µ«ÊÇ£¬½ñÌì³öÏÖÁËÒ»¸öÎÊÌ⣺
ÎÊÌâ²úÉú²½ÖèÈçÏ£º
1¡¢Æô¶¯Êý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐò
2¡¢sqlplus sys/pwd@sid as sysdbaÒÔ¹ÜÀíÔ±½øÈë
3¡¢shutdown¹Ø±ÕÊý¾Ý¿â ......
»·¾³£ºoracle 9i
±íÃû£ºtable
name time
mike 20100209-00:10:01:123
mike ......