关于 PLSQL （1）

  1.关于ORACLE 锁表 解决三部曲

   select session_id from v$locked_object;  --113
   SELECT sid, serial#, username, osuser FROM v$session where sid = 113;
   ALTER SYSTEM KILL SESSION '113,15226';

     

   2.关于已知页码和记录数从数据库取出数据  currenPage = 3 , pageSize = 5

         select IPADDR, STATE, PROPERTY from
         (select p.*, ROWNUM NUM from (select IPADDR, STATE, PROPERTY from IP where PROPERTY != 'public') P
          WHERE ROWNUM<=5*3) WHERE NUM>5*(3-1)

 

   3. 获取系统当前时间

       select sysdate, to_char(sysdate, 'yyyy-MM-dd'), to_char(sysdate, 'ww') from dual;