ÎÊÌâÌá³ö£º
Ò»¸ö¸ß¼¶SQLÓï¾äÎÊÌâ
¼ÙÉèÓÐÒ»ÕÅ±í£¬ÓÐÕâÑùһЩÊý¾Ý
a b
1 2
0 2
2 3
3 4
4
5 6
6 7
12 7
7
aÊÇ×Ó½Úµã bÊǸ¸½Úµã ,Èç¹ûbΪnull ÔòΪһ¿ÃÊ÷µÄ¸ù½Úµã
¸ù¾ÝAÓëBµÄÕâ¸ö¹Øϵ ÕÒ³öÒ»¿ÃÊ÷µÄ½á¹¹ÏÔʾ³öÀ´ £¬²¢ÏÔʾ³öÿ¸ö½ÚµãÔÚÊéÖеIJ㼶£¬½«Ê÷µÄ½á¹¹´òÓ¡³öÀ´
ÎÒÕâ±ß¼ÙÉèÊ÷×î¶àÓÐ5¸ö²ã¼¶£¬SQLÈçÏ£º
with tt as(
select 1 a,2 b from dual
union all SELECT 0,2 from dual
union all select 2,3 from dual
union all select 3,4 from dual
union all select 4,null from dual
union all select 5,6 from dual
union all select 6,7 from dual
union all select 12,7 from dual
union all select 7,null from dual)
SELECT
a
,tree_lvl
,root
,tree_lvl_path
,(CASE
WHEN tree_lvl >1 THEN SUBSTR(tree_lvl_path,1,instr(tree_lvl_path,',',1,1)-1 )
ELSE tree_lvl_path
END) COL01
,(CASE
WHEN tree_lvl <2 THEN NULL
WHEN tree_lvl =2 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,1)+1 )
WHEN tree_lvl >2 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,1)+1,instr(tree_lvl_path,',',1,2)- instr(tree_lvl_path,',',1,1)-1 )
END) COL02
,(CASE
WHEN tree_lvl <3 THEN NULL
WHEN tree_lvl =3 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,2)+1 )
WHEN tree_lvl >3 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,2)+1,instr(tree_lvl_path,',',1,2)- instr(tree_lvl_path,',',1,1)-1 )
END) COL03
,(CASE
WHEN tree_lvl <4 THEN NULL
WHEN tree_lvl =4 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,3)+1 )
WHEN tree_lvl >4 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,3)+1,instr(tree_lvl_path,',',1,3)- instr(tree_lvl_path,',',1,2)-1 )
END) COL04
,(CASE
WHEN tree_lvl <5 THEN NULL
WHEN tree_lvl =5 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,4)+1 )
WHEN tree_lvl >5 THEN SUBSTR(tree_lvl_path,instr(tree_lvl_path,',',1,4)+1,instr(tree_lvl_path,',',1,5)- instr(tree_lv
Æô¶¯“OracleDBConsole”ʱ£££³öÏÖ“Agent process exited abnormally during initialization.”
ÔÚÔËÐÐ"emctl start dbconsole "¡¡·¢ÏÖÊÇÕÒ²»µ½Ö¸¶¨Îļþ,ÔÚÍøÉÏÕÒÁËÒ»ÏÂÔÒò, ¸ü¸ÄµÄÖ¸¶¨Îļþ¼ÐµÄÃû³Æ£¬µ«»¹ÊDz»ÄÜÆô¶¯·þÎñ£¬½á¹ûÈÏÕæ¿´ÁËһϣ¬ÊÇCTRL+C,CTRL+V È»ºó²ÅÆô¶¯³É¹¦£¬ËùÒÔÌض¨Ð´ÏÂÀ´£¬¼Ç ......
×î½ü×ܽáÁËÒ»ÏÂoracleÖ÷¼üµÄÉèÖ÷½·¨£¬Ìùµ½Õâ±£´æһϰɡ£ ÓÐÁ½ÖÖ·½·¨¿ÉÒÔÉèÖÃÖ÷¼ü£¬Ò»ÖÖÊÇ×ÔÔö³¤Ö÷¼ü£¬ÁíÒ»ÖÖ¾ÍÊÇÉú³ÉΨһÐòÁС£ Ò»¡¢×ÔÔö³¤Ö÷¼ü --Ê×ÏȽ¨Ò»¸ö±íTEST
create tableTEST (
NID int PRIMARY KEY,
test1 varchar2(20),
test2 varchar2(20),
test3 ......
ÓÐʱºòÎÒÃÇ¿ÉÄܲ»ÖªµÀÒ»¸öÓû§µÄÃÜÂ룬µ«ÊÇÓÖÐèÒªÒÔÕâ¸öÓû§×öһЩ²Ù×÷£¬ÓÖ²»ÄÜÈ¥Ð޸ĵôÕâ¸öÓû§µÄÃÜÂ룬Õâ¸öʱºò£¬¾Í¿ÉÒÔÀûÓÃһЩСÇÏÃÅ£¬À´Íê³É²Ù×÷¡£
¾ßÌå²Ù×÷¹ý³ÌÈçÏ£º
SQL*Plus: Release 9.2.0.5.0 - Production on ÐÇÆÚÈÕ 11ÔÂ 21 13:32:34 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reser ......