°ïÅóÓÑ×Éѯ¸öÎÊÌ⣬3ÄêoracleÊý¾Ý¿â¿ª·¢¾Ñ飬׼±¸Ìø²ÛÓ¦¸ÃÒª¶àÉÙM¡£Éõ¼±¡£
¹¤×÷µØµãÌì½ò¡£¡£
¿´¹«Ë¾´óС°É£¬¸öÈ˸оõ£¬´ó¹«Ë¾µÄ»°5£¬6K
°ï¶¥
6K
ÖÁÉÙÒª6K
DBA»¹ÊÇÓ¦ÓóÌÐòÕë¶Ôoracle¿ª·¢°¡£¿
ǰÕß 8K£¨DBA¿É²»Ò»Ñù£¬8KÊǵ×Ïߣ©£¬ºóÕß6K£¨°´¹¤×÷ÄêË㣬¼ÙÉè±ÏÒµ3K£¬Ò»Äê¼Ó1K£©,ÓÐÆäËû¾ÑéÊʵ ......
±¾ÈËÏëÏÂÔØOracle 9i È¥¹ÙÍøÕÒÁ˰ëÌì²»ÖªµÀÊDz»ÊÇÕâ¸ö£¿ºìÉ«µÄÄǸö£¬²»ÖªµÀÄÜÔÚXPÉÏÓò»£¿Çë¸ßÈËÖ¸µã¡¡
Oracle Database 11g Release 1
Standard Edition, Standard Edition One, and Enterprise Edition
(11.1.0.7.0)
Microsoft Windows Server 2008 (32-bit) (1.9 GB) | See All (Including Client, Cluste ......
Oracle µÄʱ¼ä×Ö¶ÎÊÇtimestamp ÀàÐÍ
ÎÒÓóÌÐò¶ÁÈ¡Êý¾ÝµÄʱºò
²»ÖªµÀÓÃʲôת»»
ÎÒÓÃJava.sql.timestamp½ÓÊÕ ±¨ Oracle.sql.timestamp ²»ÄÜתjava.sql.timestampÒì³£
ÓÃObject ½Ó£¬Ö±½Ó¸øÎÒµÄÊÇoracle.sql.TIMESTAMP@166b0df ÕâÖÖÖµ
È»ºóÎÒ¶ÔËü²»ÄÜ×öSimpleDateFormat¸ñʽ»¯£¬
²»ÖªµÀÔõô¸ãÁË ......
SQL code:
select * from (select rownum rownum_,a.* from (select t.name,t.id from table_name t
order by t.name)a where rownum<=20) where rownum_>=10;
select * from (select rownum rownum_,a.* from (select t.name,t.id from table_name t
order by t.name)a) where rownum_<=20 and rownu ......
ÇóÒ»oracleÖб¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì£¬Ï£Íû¸÷λ¸ßÊÖÄܸøÎÒ¸ö²âÊÔͨ¹ýµÄ£¬²»Ê¤¸Ð¼¤£¡£¡£¡
/*±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì*/
if exists(
select * from sysobjects
where name='pr_backup_db' and xtype='p'
)
begin
drop proc pr_backup_db
end
......
ÇóÒ»²éѯoracleÊý¾Ý¿âËÀËøµÄSQLÓï¾ä
лл
°Ú¶Éһϣ¬É¶¶¼ÓÐÁË¡£¡£¡£
select C.sid,C.serial#,B.object_name,C.username,C.machine,C.terminal,C.program
from v$locked_object A,all_objects B,v$session C
where A.session_id = C.sid and A.object_id = B.object_id;
select object_id,session_id,locked ......