4,385 reputation
73785
bio website pauerschell.blogspot.com
location Germany
age 62
visits member for 3 years, 9 months
seen Nov 22 '13 at 19:11

Database developer for SQL-Server and ORACLE. Doing a lot with PowerShell.

I'm German and it is now only 4 years that I started bloging (in english) and now i'm contributing to several OpenSource Projects. Codeplex SQLPSX is the most important of them. There I'm porting SQLIse to Oracle and now to MySQL too.

If your are interested in databases and PowerShell (or other ways to use ADO.NET) please visit: http://sqlpsx.codeplex.com/


Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
I agree. I googled about it half an hour an found no simple example which led me in the right direction. I only found it by the usual tactic of commenting out portions of the code. I guess this will soon become a CW.
Jan
12
answered How to return a CTE as REFCURSOR from an Oracle stored procedure?
Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
Gotcha, missed it in the question
Jan
12
revised How to return a CTE as REFCURSOR from an Oracle stored procedure?
edited title
Jan
12
asked How to return a CTE as REFCURSOR from an Oracle stored procedure?
Jan
12
awarded  Citizen Patrol
Jan
11
revised How to compare performance of two versions of a function?
comparison fixed thanks to Matts comment
Jan
11
revised How to compare performance of two versions of a function?
1. Comment on answer
Jan
11
asked How to compare performance of two versions of a function?
Jan
11
answered How far should you go with normalization?
Jan
10
awarded  Beta
Jan
10
answered Feature comparison: Oracle Database and Microsoft SQL Server
Jan
10
revised Did anybody use sqlcmd mode in practice?
edited body
Jan
10
revised Peculiar Oracle outer join syntax case
Fixed notation
Jan
10
comment Did anybody use sqlcmd mode in practice?
I'm using sqlcmd as replacement for osql myself, but I'm not using the new features. I want to know if those where used.
Jan
9
asked Did anybody use sqlcmd mode in practice?
Jan
9
comment How does the Oracle DUAL table work?
We once even succeeded in creating our own DUAL table shading the oracles DUAL table and were able to insert and fetch more than one row from it.
Jan
9
comment What is the significance of a semicolon at the end of SQL*Plus commands?
+1 To make things more confusing, you can use / on the following line instead of the ; in some cases.
Jan
8
awarded  Commentator
Jan
8
comment Performance implications of MySQL VARCHAR sizes
+1 this question applies similar to all DBMS. My observation many varchar sizes tend to grow.