[Windows] Email of current user

Database Management and Performance
| May 21, 2012 04:00 +0000

I hate having to type my email address, so I created a long one-liner to do the trick of getting my email from Exchange and copying it in my clipboard

powershell -noprofile -command "$o=New-Object DirectoryServices.DirectorySearcher; $o.SearchRoo…

My first .NET gui in Powershell

Database Management and Performance
| May 11, 2012 07:33 +0000

I managed to interface Oracle and a GUI via powershell.
First, load the Oracle and the .NET assemblies

[void] [Reflection.Assembly]::LoadFile("C:\oracle\product\11.2.0\client_1\ODP.NET\bin\2.x\Oracle.DataAccess.dll")
[void] [Reflection.Assem…

EURO symbol, sqlplus, cmd.exe and various issues

Database Management and Performance
| May 10, 2012 04:15 +0000

One customer reported a not-correctly displayed Euro Symbol (€) in the database from sqlplus (msdos).
Why?
First, the character set did not support it.

select * from v$nls_parameters where PARAMETER like '%CHARACTERSET%';

PARAMETER    

Create helloworld.exe file in powershell

Database Management and Performance
| May 9, 2012 07:03 +0000

PS> Add-Type -outputtype consoleapplication -outputassembly helloworld.exe 'public class helloworld{public static void Main(){System.Console.WriteLine("hello world");}}'
PS> .\helloworld.exe
hello world

Probably my first .exe …

Toad 11.5 is out

Database Management and Performance
| May 8, 2012 08:08 +0000

The latest Toad is now in production, 11.5, get it from http://toadfororacle.com.
If you have an old license key, 9.6 or older, it may complain at installation time, just ignore. It will be fine at run time.
Enhanced TAB browsing experience, nicer and …