select sum(hh),sum(substr(mi,1,instr(mi,'·ÖÖÓ')-1)) from (select nvl(substr(you_col,1,instr(you_col,'Сʱ')-1),0) hh, nvl(substr(you_col,instr(you_col,'ʱ')+1),0) mi from you_table) SQL code:
with a as (select '9Сʱ20·ÖÖÓ' you_col from dual union all select '2Сʱ20·ÖÖÓ' you_col from dual union all select '55·ÖÖÓ' you_col from dual)
select floor(sum(hh *60 + substr(mi,1,instr(mi,'·ÖÖÓ')-1))/60)||'Сʱ'||(sum(hh *60 + substr(mi,1,instr(mi,'·ÖÖÓ')-1))/60-floor(sum(hh *60 + substr(mi,1,instr(mi,'·ÖÖÓ')-1))/60))*60 from (select nvl(substr(you_col,1,instr(you_col,'Сʱ')-1),0) hh, nvl(substr(you_col,instr(you_col,'ʱ')+1),0) mi from a)
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡