ÔÚOracleÖеÄÊ÷ÐβÙ×÷
ÔÚOracleÖеÄÊ÷ÐβÙ×÷
1.È¡×ӽڵ㼰·¾¶(ÕýÊ÷):
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath
from tas_catalog t
--where id!=110
start with id=110
connect by pid = prior id
order siblings by id
2.È¡¸÷¼¶¸¸½Úµã(µ¹Ê÷)£º
select t.id ,t.code, t.name ,t.pid
,SYS_CONNECT_BY_PATH(t.id,'.')||'.' as IdPath --·¾¶´Ó·´µÄ
from tas_catalog t
--where id!=110
start with id=110
connect by id = prior pid
order siblings by id
ÎÞÂÛÕýÊ÷»¹Êǵ¹Ê÷, ¹Ø¼ü¾ÍÔÚÓÚconnect byµÄÌõ¼þ.
ÕýÊ÷: ±ØÐëÊÇ ‘¸¸’= prior ‘×Ó’
µ¹Ê÷: ±ØÐëÊÇ ‘×Ó’= prior ‘¸¸’
Ïà¹ØÎĵµ£º
D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6¡¢ÐÞ¸Äoracle°²×°Â·¾¶ÏÂD:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.oraµÄtnsnames.oraÎļþ£¬Ìí¼Ó
XXX =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......
ORACLEÊý¾Ý¿â²åÈëÐÔÄܲâÊÔ
MKing
2010-3-8
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ ......
Âß¼ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡¢É ......
²âÊÔ»·¾³»ù±¾ÐÅÏ¢£º
OS£ºWindows XP sp3
DB£ºOracle 9.2.0.1 δÆôÓù鵵
DBÖØ×öÈÕÖ¾Îļþ´óС£º100MB
Ó²ÅÌÐͺţºSAMSUNG HD161GJ£¨SATA-300,160G,7200rpm,8M cache£©
CPU£ºIntel Core2 E8400£¨3.0G£©
Äڴ棺2G
ͨ¹ýHD TuneµÃµ½µÄÓ²ÅÌ»ù±¾²âÊÔÐÅÏ¢£¬
IOPS£º66
¶ÁÈ¡£º90MB/s
дÈ룺82MB/s
² ......