Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

oracle¾­ÑéÕߴͽÌ

°ïÅóÓÑ×Éѯ¸öÎÊÌ⣬3ÄêoracleÊý¾Ý¿â¿ª·¢¾­Ñ飬׼±¸Ìø²ÛÓ¦¸ÃÒª¶àÉÙM¡£Éõ¼±¡£

¹¤×÷µØµãÌì½ò¡£¡£


¿´¹«Ë¾´óС°É£¬¸öÈ˸оõ£¬´ó¹«Ë¾µÄ»°5£¬6K

°ï¶¥

6K

ÖÁÉÙÒª6K

DBA»¹ÊÇÓ¦ÓóÌÐòÕë¶Ôoracle¿ª·¢°¡£¿
ǰÕß 8K£¨DBA¿É²»Ò»Ñù£¬8KÊǵ×Ïߣ©£¬ºóÕß6K£¨°´¹¤×÷ÄêË㣬¼ÙÉè±ÏÒµ3K£¬Ò»Äê¼Ó1K£©,ÓÐÆäËû¾­ÑéÊʵ ......

Oracle 9i ÏÂÔØÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾ÈËÏëÏÂÔØ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ÀàÐͶÁÈ¡

Oracle µÄʱ¼ä×Ö¶ÎÊÇtimestamp ÀàÐÍ

ÎÒÓóÌÐò¶ÁÈ¡Êý¾ÝµÄʱºò

²»ÖªµÀÓÃʲôת»»
ÎÒÓÃJava.sql.timestamp½ÓÊÕ ±¨ Oracle.sql.timestamp ²»ÄÜתjava.sql.timestampÒì³£
ÓÃObject ½Ó£¬Ö±½Ó¸øÎÒµÄÊÇoracle.sql.TIMESTAMP@166b0df ÕâÖÖÖµ
È»ºóÎÒ¶ÔËü²»ÄÜ×öSimpleDateFormat¸ñʽ»¯£¬

²»ÖªµÀÔõô¸ãÁË ......

¹ØÓÚORACLE ´óÊý¾ÝÁ¿·ÖÒ³

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 ±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì

ÇóÒ»oracleÖб¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì£¬Ï£Íû¸÷λ¸ßÊÖÄܸøÎÒ¸ö²âÊÔͨ¹ýµÄ£¬²»Ê¤¸Ð¼¤£¡£¡£¡
/*±¸·ÝÊý¾Ý¿âµÄ´æ´¢¹ý³Ì*/
if exists(
select * from sysobjects
  where name='pr_backup_db' and xtype='p'
          )
begin
drop proc pr_backup_db
end ......

ÇóÒ»²éѯoracleÊý¾Ý¿âËÀËøµÄSQLÓï¾ä

ÇóÒ»²éѯ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 ......
×ܼǼÊý:27572; ×ÜÒ³Êý:4596; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [2370] [2371] [2372] [2373] 2374 [2375] [2376] [2377] [2378] [2379]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ