Reputation
5,255
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
16 50 93
Impact
~726k people reached

  • 0 posts edited
  • 6 helpful flags
  • 841 votes cast
Jan
18
accepted How to get rid of ORA-28002 message the password will expire within 6 days?
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
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