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;

Eclipse auto save before run

Here has the correct answer:

http://stackoverflow.com/questions/2943122/eclipse-auto-save

The second one is correct:

if 

Window -> Preferences -> General -> Workspace and there you can check "Save automatically before build" + "Build automatically" 

don't work try this 

Preferences -> Run/Debug -> Launching -> "Save dirty editors before launching"

Compile and run Java in vim

The is the original post in stackoverflow:

http://stackoverflow.com/questions/6411979/compiling-java-code-in-vim-more-efficiently

I added two lines to it:

F12 can jump out of quickfix mode
F8 can run the java program

vimrc:


autocmd Filetype java set makeprg=javac\ %
set errorformat=%A%f:%l:\ %m,%-Z%p^,%-C%.%#
map <F9> :make<Return>:copen<Return>
map <F10> :cprevious<Return>
map <F11> :cnext<Return>
map <F12> :ccl<Return>
map <F8> :!java %:r<Return>

PLSQL developer 8, oracle client 32 bit 10g and windows 7

Problem:

Even I use the 32 bit oracle client 10g on my windows 7 machine, I still can't use PLSQL developer 8 correctly. Every time I try to log in, it pops up an empty window with no error message.

Solution:

Right solution is found here:
http://stackoverflow.com/questions/3895354/allround-automations-pl-sql-developer-on-windows-7-tns-over-ip-connect-to-remo

RUN IT AS ADMINISTRATOR!!!!

Youtube has no sound in Chrome

Problem:

I was trying to play a video on youtube in Chrome. It has the video but with no sound. The system speaker works fine and I can listen to the music played by the media player. Therefore, the conclusion is that there is something wrong with Chrome.

Solution:

Open an IE and set it as default browser. Then restart Chrome.