Notifying Database Change Events (ORACLE)

http://docs.oracle.com/cd/B28359_01/java.111/b31224/dbmgmnt.htm

Example 29-2 


Very useful.

AIX netstat show PID

Refer to: https://www.ibm.com/developerworks/community/blogs/brian/entry/determine_which_processes_have_listening_ports_on_aix15?lang=en


The netstat command in AIX is a little bit different.

# netstat -Aan | grep LISTEN | grep 30001
f100050000b05bb8 tcp

# rmsock f100050000b05bb8 tcpcb

Eclipse doesn't show right color under Ubuntu

Refer to:
http://askubuntu.com/questions/70599/how-to-change-tooltip-background-color-in-unity

Install and open gnome-color-chooser .
Go to Specific → Tooltips and put black foreground over pale yellow background.

Error creating managed object for class org.jboss.weld.servlet.WeldListener

I choose to let glassfish publish new changes automatically and when I was adding @Named to one EJB, this error popped up.

Solution: Restart Eclipse and it is gone.

Procedure compiled with errors

select * from SYS.USER_ERRORS where NAME = 'PROCEDURE NAME' and type = 'PROCEDURE'


show errors procedure sonica.PALLET_DESTACKER_TEST

Select Nth Row From A Table In Oracle

Original link:
http://stackoverflow.com/questions/4509167/select-nth-row-from-a-table-in-oracle


select * 
  from ( select a.*, rownum rnum
           from ( YOUR_QUERY_GOES_HERE  ) a
          where rownum <= N_ROWS )
 where rnum >= N_ROWS

Search a string in clob ---ORACLE

replace table_name, column_name and string

select * from table_name where dbms_lob.instr(column_name,'string')>0;