Sonntag, 27. Juli 2014

Wake-On-Lan Broadcast DIR-826l

In Firefox, in Firebug's console, execute the following: check_LAN_ip=function(){return true;}; check_address=function(){return true;}; and then try to save the settings. Let me know if it works.

Freitag, 2. Mai 2014

Tabelle Flachklopfen

 SELECT * FROM (  
 SELECT 'OA' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OB' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OC' OBJECT_NAME, 'EU' REGION FROM DUAL UNION ALL  
 SELECT 'OA' OBJECT_NAME, 'US' REGION FROM DUAL UNION ALL  
 SELECT 'OB' OBJECT_NAME, 'AS' REGION FROM DUAL UNION ALL  
 SELECT 'OC' OBJECT_NAME, 'AS' REGION FROM DUAL ) S  
 PIVOT (COUNT (*) FOR REGION IN ('EU', 'US', 'AS'))  

Freitag, 25. April 2014

Linux Mint gedit Problem

The following packages have unmet dependencies: gedit-plugins : Depends: gedit (>= 3.8) but 2.30.5+petra is to be installed E: Unable to correct problems, you have held broken packages. apt purge gedit gedit-common apt install gedit/saucy gedit-common/saucy Source:

Donnerstag, 10. April 2014

ORA-01007: variable not in select list

the Problem was a DB-Link has been recreated and the Objects on that Schema had not been recompiled. SET SERVEROUTPUT ON; DECLARE c SYS_REFCURSOR; s_dummy VARCHAR2 (1); s_dummy_culprit VARCHAR2 (1); BEGIN OPEN c FOR 'select dummy from dual'; FETCH c INTO s_dummy, s_dummy_culprit; --<== here is the problem CLOSE c; END; /

Freitag, 28. März 2014

Dienstag, 25. Februar 2014

Notepad++ Makro Generator "Find In Files"

1:  SET SERVEROUTPUT ON;  
2:  SET LINES 256  
3:  SET TRIMOUT ON  
4:  SET SPACE 1  
5:  SET tab OFF  
6:  DECLARE  
7:   dummy  NUMBER;  
8:  BEGIN  
9:   FOR n IN (SELECT 'A.B' func FROM DUAL  
10:        UNION ALL  
11:        SELECT 'A.C' func FROM DUAL) LOOP  
12:    DBMS_OUTPUT.put_line ('<Action type="3" message="1700" wParam="0" lParam="0" sParam="" />');  
13:    DBMS_OUTPUT.put_line ('<Action type="3" message="1601" wParam="0" lParam="0" sParam="' || n.func || '" />');  
14:    DBMS_OUTPUT.put_line ('<Action type="3" message="1625" wParam="0" lParam="0" sParam="" />');  
15:    DBMS_OUTPUT.put_line ('<Action type="3" message="1653" wParam="0" lParam="0" sParam="C:\repo_facts\branches\" />');  
16:    DBMS_OUTPUT.put_line ('<Action type="3" message="1652" wParam="0" lParam="0" sParam="*.*" />');  
17:    DBMS_OUTPUT.put_line ('<Action type="3" message="1702" wParam="0" lParam="32" sParam="" />');  
18:    DBMS_OUTPUT.put_line ('<Action type="3" message="1701" wParam="0" lParam="1656" sParam="" />');  
19:   END LOOP;  
20:  EXCEPTION  
21:   WHEN NO_DATA_FOUND THEN  
22:    NULL;  
23:   WHEN OTHERS THEN  
24:    NULL;  
25:  END;  
26:  /  

Samstag, 25. Januar 2014

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 {} \; &


Mittwoch, 22. Januar 2014

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