Month: September 2006

duplicate post of ./soug-last-week-2.html

The documents from last SOUG special interest group with Tom Kyte are now available for downloadable on the soug.ch homepage (under history). The day started with Sven Vetter, who talked about SLA management pack for Enterprise Manager Grid Control 10gR2. We saw also how to define a custom shell script and let OEM generate a […]

Sunday, November 26th, 2006, I will defend my Title in the Chinese Chess Swiss Championship. It is free and open to anyone !

Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)

There is a bug about NLS_LANG and SWITZERLAND in 10g. This is because the tausend separator has changed from 9i (.) to 10g (‘). Check Note 4598613.8 The workaround is to not use NLS_LANG=german_switzerland, but if you have different NLS parameters on the client and on the server, than you will have other problems, ex: […]

blogger meetup organized by Mark Rittman

I often see questions like How do you get the row of each department with the highest salary In case you only want 1 row, you have two modern solutions : Analytics, which is trend, and KEEP, which is not very known The old fashion would be something like where s in (select max()) Ok, […]

On wednesday, there is a DBA day in the SOUG community. DBA-SIG 06/4 The highlight of this session will be Tom Kyte, speaking about Oracle System Architecture. Check the homepage of SOUG.CH for registration

Tomorrow LC Systems is organizing an event about Identity Management in Zurich. The focus will be on Sun Java System Directory Server and Oracle Virtual Directory.

wget is a well-known command line utility for downloading files from the internet/intranet. I like to use the limit-rate, so that my coworkers still can surf. Until today, I never succeeded to download from otn, because wgetting software required me to log in and accept the export restriction How to automate login is actually extremly […]

I just discovered that cool new function in SQL/Developer just right click on the table and chose export sql insert — INSERTING into EMP Insert into “EMP” (“EMPNO”,”ENAME”,”JOB”,”MGR”, “HIREDATE”,”SAL”,”COMM”,”DEPTNO”) values (7369 ,’SMITH’,’CLERK’,7902,to_date(‘1980-12-17’, ‘DD-MON-RR’),800,null,20); Insert into “EMP” (“EMPNO”,”ENAME”,”JOB”,”MGR”, “HIREDATE”,”SAL”,”COMM”,”DEPTNO”) values (7499 ,’ALLEN’,’SALESMAN’,7698,to_date(‘1981-02-20’, ‘DD-MON-RR’),1600,300,30); Insert into “EMP” (“EMPNO”,”ENAME”,”JOB”,”MGR”, “HIREDATE”,”SAL”,”COMM”,”DEPTNO”) values (7521 ,’WARD’,’SALESMAN’,7698,to_date(‘1981-02-22’, ‘DD-MON-RR’),1250,500,30); Insert into “EMP” (“EMPNO”,”ENAME”,”JOB”,”MGR”, […]

Register in Paris (18-19 sep), Zurich (21-22 sep) or Wien (25-26 sep) at oracle university for the tom kyte workshop. Lutz Hartmann wrote about this event in his blog