Oracle ÅÅÐò
Oracle ÅÅÐò
ÎÒÏÖÔÚÓÐÒ»¸öÕâÑùµÄÎÊÌâ:
±ÈÈçÎÒÓÐÊý¾ÝÈçÏÂ:
10
1001
1002
1003
1004
20
2001
2002
2003
.....
ÎÒÒªÅÅÐò³ÉÈçϸñʽ:
1001
1002
1003
1004
10
2001
2002
2003
20
...
ÇëºÃÐĵĸ÷λ´óÏÅ£¬°ï°ïÎÒ¡£¡£¡£
ÔÚÏߵȺòÔÚÏŵĻظ´¡£¡£
лл£¡
SQL> with table1 as(
2 select 10 id from dual union all
3 select 1001 from dual union all
4 select 1002 from dual union all
5 select 1003 from dual union all
6 select 1004 from dual union all
7 select 20 from dual union all
8 select 2001 from dual union all
9 select 2002 from dual union all
10 select 2003 from dual
11 )
12 select id from table1 order by substr(id,0,1),length(id) desc,substr(id,length(id),1);
ID
----------
1001
1002
1003
1004
10
2001
2002
2003
20
9 rows selected
Èç¹ûÊý¾ÝÊÇÒª×ó¶ÔÆëµÄ»° ¼Ó¸öto_char
<
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......