Reputation
4,719
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
12 46 90
Impact
~601k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Jan
14
comment adding an order by to this query returns faster than without, why?
Where is the alias c defined?
Jan
14
answered Why can't I read Oracles CLOB columns via SQL-SERVER 2008 linked server?
Jan
14
comment Randomizing table contents and storing them back in the table
Which DBMS do you use and which data type has your key column?
Jan
14
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
@Leight Riffel Going to think about it this weekend. I'll try some Google queries and keep the part with more hits. BTW uses Orcale the term CTE or has it its own idiom?
Jan
13
accepted Did anybody use sqlcmd mode in practice?
Jan
13
accepted Is there anybody using the SQL Server feature to create groups of stored procedures differentiated by number?
Jan
13
accepted Can I change the SID of an Oracle database?
Jan
13
comment Can I change the SID of an Oracle database?
I renamed 4 oracle databases on a Windows Server this way. Searching for dbnewid utility I found oracle-base.com/articles/9i/DBNEWID.php which gave some additional explanations.
Jan
12
comment How to return a CTE as REFCURSOR from an Oracle stored procedure?
I started with one complete example. I think the the question deserves at least another example using input parameters. The special problem of sql-server -> Oracle migration pitfalls deserve(s) its own question(s).
Jan
12
revised How to return a CTE as REFCURSOR from an Oracle stored procedure?
Added one complete basic example
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?