Toad Navigator wieder einblenden

Code Formatter for Blogspot

http://codeformatter.blogspot.ch

unrar all files in a directory

Ohne Passwort

  nohup find . -regex \.\*part[0]?[0]?1.rar -exec unrar x -inul {} \; & 

Mit Passwort

  nohup find . -regex \.\*part[0]?[0]?1.rar -exec unrar x -inul -pPASSWORD {} \; &

pyLoad@nas doesn't unpack after download

be shure that you have installed unrar and unzip

then go into /bin

cd /bin

find the location of unrar an unzip:

find / -iname unrar
find / -iname unzip

now create two symlink:

ln -s /opt/bin/unrar
ln -s /opt/bin/unzip

Now pyLoad should extract after finish downloading a package

PL/SQL Generate Range of number

I had the problem to select a number field with leading blanks.. this is my solution:


SELECT LPAD (
             LEVEL + doc_num_from - 1
            ,12
            ,' '
            )
         AS rnum
  FROM DUAL
CONNECT BY LEVEL < doc_num_to - doc_num_from + 2