Tuesday, July 24, 2012

AUTO LOG WITH TRIGGER



create
TRIGGER TRIG_MYTBL_LOG AFTER
  UPDATE ON  MYTBL  FOR EACH ROW BEGIN
  INSERT
  INTO  MYTBL_LOG
    (
      ITEM_CODE,
      GTIN,
      REGID,
      REGIP,
      REGDATE
    )
    VALUES
    (
      :OLD.ITEM_CODE,
      :OLD.GTIN,
      :OLD.REGID,
      :OLD.REGIP,
      :OLD.REGDATE
    );
END;

Share Article : AUTO LOG WITH TRIGGER
Share/Save/Bookmark

Tuesday, July 17, 2012

How to Delete all .svn folders using Windows Command Prompt



You can use the following command to delete all .svn folders in curent directory recursively.

FOR /R . %f IN (.svn) DO RD /s /q %f

Share Article : How to Delete all .svn folders using Windows Command Prompt
Share/Save/Bookmark

Saturday, July 14, 2012

Recursive Permission




Share Article : Recursive Permission
Share/Save/Bookmark

Friday, March 9, 2012

Killing an Oracle session to remove a LOCK


Get List of LOCKS

SELECT  l.inst_id,
SUBSTR(L.ORACLE_USERNAME,1,8) ORA_USER,
SUBSTR(L.SESSION_ID,1,3) SID,
S.serial#,
SUBSTR(O.OWNER||'.'||O.OBJECT_NAME,1,40) OBJECT, P.SPID OS_PID,
DECODE(L.LOCKED_MODE,   0,'NONE',
1,'NULL',
2,'ROW SHARE',
3,'ROW EXCLUSIVE',
4,'SHARE',
5,'SHARE ROW EXCLUSIVE',
6,'EXCLUSIVE',
NULL) LOCK_MODE
FROM    sys.GV_$LOCKED_OBJECT L
, DBA_OBJECTS O
, sys.GV_$SESSION S
, sys.GV_$PROCESS P
WHERE     L.OBJECT_ID = O.OBJECT_ID
  and     l.inst_id = s.inst_id
  AND     L.SESSION_ID = S.SID
  and     s.inst_id = p.inst_id
  AND     S.PADDR = P.ADDR(+)
order by l.inst_id

Just a matter of Killing 
ALTER SYSTEM KILL SESSION 'sid#,serial#' IMMEDIATE;

Share Article : Killing an Oracle session to remove a LOCK
Share/Save/Bookmark