Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÈçºÎÓÃoracleÕýÔòÈ¡³ö¸ñʽ»¯µÄÊý¾Ý

ÎÒµÄÊý¾Ý½á¹¹ÈçÏÂ:
0-´ó·ÖÀà±àºÅ-¶þ·ÖÀà±àºÅ-Èý·ÖÀà±àºÅ:´ó·ÖÀàÃû-¶þ·ÖÀàÃû-Èý·ÖÀàÃû
ÀýÈç:
0-103-1508:ʱÉмҵç-µçÆ÷¸½¼þ
0-320-1414-1474:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-À¬»ø´ü1
0-320-1414-1469-1471:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-±£ÏÊĤ1-±£ÏÊ´ü1

ÏÖÔÚ,ÎÒҪȡ³ö¶þ·ÖÀàÃû(ÀýÈçµÚÒ»ÌõÈ¡³ö:¼Òµç¸½¼þ,µÚ¶þÌõÈ¡³ö:Ò»´ÎÐÔÓÃÆ·,µÚÈýÌõÈ¡³ö:Ò»´ÎÐÔÓÃÆ·),ÓÃoracleÕýÔò¸ÃÔõôд±È½Ï¼ò½à?


²Î¿¼ÎÒµÄblog£ºOracle 10g ÕýÔò±í´ïʽ
http://blog.csdn.net/tianlesoftware/archive/2009/11/12/4799552.aspx


------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
Q Q Ⱥ£º62697716


select regexp_substr(regexp_replace(a,'.+:[^-]+-'),'[^-]+') from tt
ÕâÑùÒ²ÐÐ
¿´¿´ÓÐûÓиü¼òµ¥µÄд·¨

ÒýÓÃ
with tt as(
  select '0-103-1508:ʱÉмҵç-µçÆ÷¸½¼þ' a from dual
  union all select '0-320-1414-1474:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-À¬»ø´ü1' from dual
  union all select '0-320-1414-1469-1471:³øÎÀÇå½à-Ò»´ÎÐÔÓÃÆ·-±£ÏÊĤ1-±£ÏÊ´ü1' from dual
  )


select ltrim(regexp_substr(a,'(-)(\w+)',instr(a,':')),'-') from tt

»òÕß
select regexp_replace(subs


Ïà¹ØÎÊ´ð£º

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

Ë­ÄÜÍÆ¼ö¼¸±¾oracleµÄÊé»òÊÓÆµ - Oracle / ·Ç¼¼ÊõÇø

лл
ÎÒÒ²ÊÇÏëÖªµÀ

me too

ÎÒ Ò² Ïë Öª µÀ Æä Ëû µÄ£¬ÎÒ ÏÖ ÔÚ ¾Í ÔÚ Ñ§ orcale Êý ¾Ý ¿â£¬ÎÒ 
Óà µÄ ÊÇ ÕÔ Ôª ½Ü ±à µÄ.......

¸öÈ˾õµÃÔ­ÀíÐԵĶ«Î÷¿´Ò»Ð©¹Ù·½Îĵµ¿ÉÄÜ»áºÃһЩ Èç¹ûûÓÐÀÏʦ½Ì ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

SQL²éѯÎÊÌ⣨oracle) - Oracle / ¿ª·¢

ÈçÏÂ2ÕÅ±í£º
table1:
node_id
parent_id
root_id
value
table2:
node_id
status
±í1´æ´¢ÁËÒ»¿ÃÊ÷£¬±í2´æ´¢Á˽ڵã״̬£¬ÎÊÌâÈçÏ£º
ÈçºÎÓÃSQLÓï¾ä»ñµÃ״̬statusΪ1µÄ½ÚµãµÄËùÓÐ×Ó½ÚµãÒÔ¼°ÆäÏÂ×ÓÊ÷ÖÐËùÓÐ½Ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ