ORACLEÖÐÓÃrownum·ÖÒ³²¢ÅÅÐòµÄSQLÓï¾ä
µÚÒ»ÖÖ£º
select b.* from
( select a.*, rownum row_num from
(select t.* from A05_ORGANIZATION t order by org_name_en asc) a
) b
where b.row_num between 1 and 5 order by b.row_num asc
µÚ¶þÖÖ£¨¸ü¸ßЧ£©£º
select b.* from
( select a.*, rownum row_num from
(select t.* from A05_ORGANIZATION t order by org_name_en asc) a
where rownum <=5
) b
where b.row_num >=1 order by b.row_num asc
Ïà¹ØÎĵµ£º
exists £¨sql ·µ»Ø½á¹û¼¯ÎªÕ棩
not exists (sql ²»·µ»Ø½á¹û¼¯ÎªÕ棩
ÈçÏ£º
±íA
ID NAME
1 A1
2 A2
3 A3
±íB
ID AID NAME
1 1 B1
2 & ......
1¡¢oracle½ø³ÌÌåϵ½á¹¹
2¡¢oracleÄÚÖöÔÏó
3¡¢¹ØÓÚoracleÔÚÏßÈÕÖ¾¡¢¹éµµÈÕÖ¾¡¢Êý¾Ý¿â»Ö¸´¡¢rman
4¡¢Ñ§Ï°goldengateµÄÅäÖÃ
5¡¢¹ØÓÚoracleµÄ¸÷°æ±¾Éý¼¶·½·¨£»
½«oracle10g Éý¼¶ÖÁ10.2.0.4
http://www.cnblogs.com/zhou__zhou/archive/2009/10/07/oracle_patch.html ......
http://gaoshan.blog.51cto.com/742525/284057
Ò»¡¢¸ÅÊö
´Ó9.2°æ¿ªÊ¼, Oracle¹«Ë¾Éè¼ÆʵÏÖÁ˸ö±ð²¹¶¡"×°¹ÜÀí¹¤¾ßopatch. opatchʹÓÃÒ»¸ö³ÆΪinventoryµÄϵͳÊý¾Ý½á¹¹(Ñϸñ˵ÊÇÓëoui¹²Ïíinventory), ¼¯ÖйÜÀíËùÓÐÒÑ°²×°µÄ¸ö±ð²¹¶¡; ¸ö±ð²¹¶¡µÄ°²×°ºÍжÔض¼Ê¹ÓÃopatchÃüÁîÍê³É, ³åÍ»¼ì²âÒ²ÓÉopatchÔÚ°²×°Ê±×Ô¶¯Íê³É; ÌṩÁÐ ......
select sql_text, spid, v$session.program, process
from v$sqltext, v$session, v$process
where v$sqltext.address = v$session.sql_address
and v$sqltext.hash_value = v$session.sql_hash_value
and v$session.paddr = v$process.addr
and v$process.spid in (4335);
×¢Ò ......
Ç°ÃæÓÐTXÁôÑÔÎÊ·ÖÒ³µÄsqlÊÇÔõôÑùµÄ£¬¿´ÍêÕâƪÄãÒ²¾ÍÖªµÀÁË¡£ ×é¼þ¿ÉÒÔÊä³öÖ´ÐеÄsql£¬·½±ã²é¿´sqlÉú³ÉµÄÓï¾äÊÇ·ñÓÐÎÊÌâ¡£ ͨ¹ý×¢²áʼþÀ´Êä³ösql DbSession.Default.RegisterSqlLogger(database_OnLog);
private string sql;
void database_OnLog(string logMsg)
{
//±£´æÖ´ÐеÄDbCommand (sqlÓï ......