OpenHut - tech chats

SELECT OBJECT_NAME,OBJECT_TYPE,SESSION_ID,TYPE,LMODE,REQUEST,BLOCK,CTIME FROM  V$LOCKED_OBJECT, ALL_OBJECTS, V$LOCK WHERE   V$LOCKED_OBJECT.OBJECT_ID = ALL_OBJECTS.OBJECT_ID AND   V$LOCK.ID1 = ALL_OBJECTS.OBJECT_ID AND   V$LOCK.SID = V$LOCKED_OBJECT.SESSION_ID ORDER BY   SESSION_ID, CTIME DESC, OBJECT_NAME;

select count(field_name),field_name from table_name where field_name group by field_name having count(field_name) > 1 ;

$ lsb_release -a  

$ sudo apt-get install eclipse eclipse-cdt eclipse-JDT

Output stores in a new file: $ grep -i -r "keyword" *.* > filename.txt Output stores in a existing file(appended): $ grep -i -r "keyword" *.* >> filename.txt