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

ÀÏÎÊÌ⣺OracleÐÐתÁУ¨×Ö·û´®²ð·Ö£©

ÏÖÓÐÒÔÏÂÊý¾Ý£º
ID Name
1 Jack,Tom,Ben
2 Mary,Simth,Tony,Jay


ת»»Îª£º
ID Name
1 Jack
1 Tom
1 Ben
2 Mary
2 Simth
2 Tony
2 Jay

ÒªÇóʹÓÃSQL²éѯÍê³É£¬ÓÉÓÚÌõ¼þÏÞÖÆ£¬²»ÄÜʹÓú¯Êý£¬¹ý³Ì£¬ÓαêÖ®ÀàµÄ·½·¨¡£
Çë´óϺÃÇ°ïæ°É£¡
SQL code:
with tt as (select 1 id,'Jack,Tom,Ben' Name from dual
union all select 2,'Mary,Smith,Tony,Jay' from dual)

select a.id,
substr(','||a.name||',',instr(','||a.name,',',1,b.rn)+1,
instr(a.name||',',',',1,b.rn)-instr(','||a.name,',',1,b.rn))name
from tt a,
(select rownum rn from dual
connect by rownum<10)b
where length(a.name)-length(replace(a.name,','))+1>=b.rn
order by id,b.rn

Õâ¸ö10Òª°´ÄãµÄʵ¼ÊÇé¿öÐÞ¸Ä
²»Ð¡ÓÚÔ­±íÖÐnameÀïÏîÊýµÄ×î´óÖµ


with tt as ( 
select 1 id,'Jack,Tom,Ben' Name from dual 
union all select 2,'Mary,Smith,Tony,Jay' from dual 

select substr(name, 
  decode(rownum, 1, 1, instr(name, ',', 1, rownum - 1)+1), 
  instr(name, ',', 1, rownum) - 
  decode(rownum, 1, 1, instr(name, ',', 1, rownum - 1)+1)) 
  from (select wmsys.wm_concat(name)||',' name from tt) a 
connect by rownum <= 5 and instr(name, ',', 1, rownu


Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈË°ïÖúÏ°¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

adoÁ¬½ÓoracleµÄ¹ÖÎÊÌâ

ÒÔÇ°³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
        ::CoInitialize(NULL);
        hr=m_pConnection.Creat ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

HP-UXÖÐÓ¦ÓóÌÐòÎÞ·¨Æô¶¯oracle 10g

ÔÚHP-UX°²×°HPÐÔÄÜÕ¹ÏÖ²úÆ·OVPI£¬°²×°¹ý³ÌÐèҪֹͣOracleÊý¾Ý¿âʵÀý£¬²¢Æô¶¯¡£Êý¾Ý¿â˳ÀûÍ£Ö¹ºó£¬È»ºó¾ÍÒ»Ö±´¦ÓÚÆô¶¯×´Ì¬£¬²¢ÇÒ²»±¨´í£¡ÎÊÌâ»á³öÔÚʲôµØ·½ÄØ£¿
¶¥Ò»Ï£¡¸÷λÇë°ï棡

¶¥Ò»Ï£¡¸÷λÇë°ï棡

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