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

ÇóÒ»ÌõSQLÓï¾ä¡£¡£ - Oracle / »ù´¡ºÍ¹ÜÀí

±íÀïÓÐÒ»¸öʱ¼ä×ֶΣ¬ÀàÐÍÊÇvarchar
ÀýÈç:

  ÐòºÅ ʱ¼ä
  1 9Сʱ20·ÖÖÓ
  2 2Сʱ20·ÖÖÓ
  3 55·ÖÖÓ


ͨ¹ýÒ»ÌõSQLÓï¾ä£¬µÃµ½Ê±¼ä×ֶεÄ×Üʱ¼ä£¬¼´µÃµ½×Üʱ¼äµÄ½á¹û£º12Сʱ35·ÖÖÓ¡£
  
лл´ó¼ÒÁË¡£

 
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)


12Сʱ34.9999999999999999999999999999999999998




¸ø·Ö¸ø·Ö

ÒýÓÃ
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)

sel


Ïà¹ØÎÊ´ð£º

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

SQL·ÖÒ³ÓëOracle·ÖÒ³µÄÒÉÎÊ£¿ - Java / Web ¿ª·¢

ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ãæ£¬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......

oracle ÈçºÎµ÷ÓÃmssql´æ´¢¹ý³Ì - Oracle / ¸ß¼¶¼¼Êõ

oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~
ÒýÓÃ
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......

¹ØÓÚSqlµÄÎÊÌâ - .NET¼¼Êõ / ASP.NET

½«Ò»¸ö²éѯÓï¾ä¸³¸øÒ»¸ö±äÁ¿£¬ÈçÏ£º
DECLARE @STR NVARCHAR(MAX)
SET @STR='SELECT * from SALE_PROD'
ÔõôÑù²ÅÄÜÖ´ÐÐËüÄØ£¿
Çë¸ßÊÖ£¬ÈÊÐÖ£¬ÏÀ½ã°ï°ïæ°¡


¶àл£¬¿ÉÒÔÀ²£¬¸ßÊÖ°¡

Ö±½ÓÖ´ÐоÍÐÐÁË

exec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ