duplicate post of ./soug-last-week-2.html
Month: September 2006
SOUG last week
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 […]
Xiang-Qi
Sunday, November 26th, 2006, I will defend my Title in the Chinese Chess Swiss Championship. It is free and open to anyone !
10gR2 solaris x86 is out
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
NLS_LANG=german_switzerland
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: […]
OOW2006 Blogger Meetup : Tuesday 24th October, Thirsty Bear Brewing Company, 7pm
blogger meetup organized by Mark Rittman
KEEP DENSE_RANK versus ROW_NUMBER()
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, […]
Swiss Oracle User Group
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
_Workshop _be_informed_
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 from otn
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 […]
generate dml
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”, […]
Tom Kyte in France, Switzerland and Austria
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