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

ÔÚOracleÖÐÈçºÎÈ¥µôÕâÑùµÄÖØ¸´ÐÐ - Oracle / ¸ß¼¶¼¼Êõ

ÔÚOracleÖвéѯµÃµ½ÀàËÆÕâÑùµÄ½á¹û£º
a b ab
1 2 1,2
2 1 2,1
ÈçºÎÈ¥µôÆäÖÐÈÎÒâÒ»Ìõ¼Ç¼
select * from table1 t
where not exists(
  select 1 from table1 where a=t.b and b=t.a and a>t.a)

SQL code:
with temp as(
select 1 a,2 b,'1,2' ab from dual
union all
select 2 a,1 b,'2,1' ab from dual
)
select * from temp where a = (round(dbms_random.value)+1)


ÒýÓÃ
select * from table1 t
where not exists(
select 1 from table1 where a=t.b and b=t.a and a>t.a)

ÒýÓÃһϿñÀ˵쬏ÄÒ»ÏÂ:
delete from table1 t
where exists(
  select 1 from tmp where a=t.b and b=t.a and a<t.a)

and rownum=1 ¼Ó¸öÕâ¸ö
¾ÍÑ¡³öÒ»ÌõÁË,

ÒýÓÃ
ÔÚOracleÖвéѯµÃµ½ÀàËÆÕâÑùµÄ½á¹û£º
a b ab
1 2 1,2
2 1 2,1
ÈçºÎÈ¥µôÆäÖÐÈÎÒâÒ»Ìõ¼Ç¼


Â¥Ö÷µÄÃèÊö¸úÎÊÌâÑÏÖØ²»·ûºÏ°¡£¡

¸ù¾ÝÎÊÌâÃèÊö£¬È¥µôÈÎÒâÒ»Ðеϰ£¬delete from tb where rownum=1; ¾ÍºÃÁË¡£

ÖÁÓÚÖØ¸´ÐмǼȥµôµÄ£¬Òª¿´Óм¸¸ö×ֶΣ¬²ÅºÃдsqlÓï¾ä£¬¼ÓÈëÄã±ítb ÓÐidÖ÷¼ü¡¢c1¡¢c2¡¢c3¡£ÄÇÃ´ÖØ¸´µÄ¼Ç¼¾ÍÊÇc1¡¢c2¡¢c3×Ö¶ÎÖØ¸´°É¡£
ÄÇôɾ³ýÖØ¸´ÐеÄsql¾ÍÊÇ
delete from tb t2
where exists(select 1 from tb t1 where t1.c1=t2.c1 and t1.c2=t2.c2 and t1.c3=t2.c3 and t1.id<>t2


Ïà¹ØÎÊ´ð£º

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

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

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

oracle °²×° 01092 ´íÎó - 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 / ......

oracleµÄ°²×°ºÍʹÓúÃÄѰ¡ - Java / Java EE

oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿Ô­À´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......

oracle ¿ÉÊÓ»¯¿´±íÄÚÈÝ - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒ°²×°ÁËoracle 10g¾­¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......

·ÖÏí×Ô¼ºµÄOracleÅäÖùý³Ì - Oracle / »ù´¡ºÍ¹ÜÀí

Ð»Ð»ÌÆÈËÀÏ´óµÄÖ¸µã£¬Ð»Ð»¸÷λ¸ßÊÖµÄÖ¸µã£¡
°²×°10g Enterprise¡£ÉÏÍøÏÂÁËMLDNµÄOracleÊÓÆµ£¬¸ú×ÅÊÓÆµÉϵÄÅäÖÃ×ߣ¬°²×°³É¹¦ÁË£¬µ«ÊÇûÍêÕûµØÅäÖá£
µã»÷½øÈ룺Database Configuration Assistant
1. ´´½¨Êý¾Ý¿â£» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ