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

ÇóÒ»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            ......

Çóoracle¿âÀïµÄ±í½á¹¹µ¼µ½PDÈí¼þÖеķ½·¨£¿£¿£¿£¿

СµÜ×î½üÔÚʹÓÃPD,ÎÒÏÖÔÚÓõÄÊÇoracleÊý¾Ý¿â£¬¿âÀïµÄ±íÔç¾ÍÒѾ­½¨ºÃÁË£¬
ÎÒÏÖÔÚÊÇÏëÓÐûÓÐʲô·½·¨£¬°Ñoracle¿âÀïµÄ±í½á¹¹µ¼µ½PDÈí¼þÖС£
ÓÃPDÁ¬½ÓÄ¿±êÊý¾Ý¿â£¬È»ºó¶ÔÊý¾Ý¿â½øÐÐÄæ¹¤³Ì¡£

лл¥ÉϵÄÐֵܣ¬ÎÒÈ¥ÊÔÊÔ£¡

PDÒѾ­Á¬½ÓÉÏÁËÄ¿±êÊý¾Ý¿â£¬½ÓÏÂÀ´ÐèÒªÔõôÑù×ö²ÅÄܵ¼Èë±í½á¹¹£¡




ÖÕÓÚÕÒµ½ÁË£¬Ð»Ð»Â¥É ......

ÄÄλÓùýoracle apex£¬ÖªµÀ±¨±íµÄ¸ßÁÁÏÔʾ

ÄÄλÐǪ̈Óùýoracle apex.ÎÒÓÐÒ»¸ö±¨±í£¬ÆäÖÐһЩÐÅÏ¢ÐÐÐèÒª¸ßÁÁÍ»³öÏÔʾ£¬²»Öª
ÈçºÎ²Ù×÷£¬ÖªµÀµÄÖ¸µãϹþ

ûÈËÓùýapexô£¬ÄÇôÓÐûÓÐʲô·½·¨¿ÉÒÔ´Óselect²éѯ³öµÄ½á¹ûÖУ¬½«ÎÒÏ£ÍûÍ»³öÏÔʾµÄÐÅÏ¢¸ßÁÁÏÔʾ


¹ýÍêÄêÀ­¡£À´¸ö¸ßÈ˰É

HELP

Í·Í´
......
×ܼǼÊý:1827; ×ÜÒ³Êý:305; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [98] [99] [100] [101] 102 [103] [104] [105] [106] [107]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ