Reputation
4,699
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
11 45 90
Impact
~582k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Jan
17
answered Building Dynamic Oracle Where Clause
Jan
17
answered How to get rid of ORA-28002 message the password will expire within 6 days?
Jan
17
comment How to get rid of ORA-28002 message the password will expire within 6 days?
I want to keep the same password
Jan
17
asked How to get rid of ORA-28002 message the password will expire within 6 days?
Jan
16
answered Passing array parameters to a stored procedure
Jan
15
comment Passing array parameters to a stored procedure
The accepted answer seems to answer D. Lamberts problem, but not the question taken verbatim. The question not only covers the case where the data comes from another stored procedure, but also the case where the data comes from ado.net or another API. This part is answered by sommarskog.se/arrays-in-sql-2008.html#ADONET which is mentioned in the above link. I think this link deserves to be included in this answer.
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