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
May
29
comment Mapping SQL Server integer to Oracle Datatype
The only practical problems I encountered so far, occurred when porting back from Oracle to SQL-Server are with date to dateime when used to contain time only values. But migration back is the exception.
May
28
comment Mapping SQL Server integer to Oracle Datatype
In this special case no. But generally We (the developers) always hope that the Oracle database administrator of our customers retire and we can migrate the house to SQL Server.
May
16
comment Oracle Import problem caused by different character sets
I changed my table definition ...VARCHAR2(60 CHAR) NOT NULL ... and used IMP with IGNORE=Y and Import terminated successfully with warnings.
May
16
comment Oracle Import problem caused by different character sets
I have the create table script and can modify it according to your proposal. If imp works when the tables are already created, all would be fine.
May
16
comment Oracle Import problem caused by different character sets
not yet, but perhaps a good time to learn.
May
16
comment Oracle Import problem caused by different character sets
See my edit. My only hope is to first create the tables with extended width and than import the data ignoring the create tables from the import.
May
16
comment I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
The true sql statement is tuned to be less than 4000 char. It has to run on 10g. But printed to output and coped to a file it got 415 KB due to trailing blanks.
May
13
comment I get ORA-13605 when trying to run SQL Tuning Advisor from SQL Developer
I tried this in different VMs and with different users. It works sometimes, but after analyzing some long query I get the problem.
May
6
comment Is there a way to load a sql script with a specified encoding into a running SQL Server Management Studio (SSMS)?
and OEM 437 and OEM 850
May
6
comment Query execution time in Oracle SQL Developer
In German versions it is called Fortschritt - Task
May
4
comment What is the difference between select count(*) and select count(any_non_null_column)?
The main question is not which one runs faster, but if they return the same value
May
3
comment What does TOAD do, when I terminate script execution?
Now I have 119MB tracefile. What now?
May
3
comment What does TOAD do, when I terminate script execution?
There is a lot of analytical functions Rank() OVER (PARTITION
May
3
comment What does TOAD do, when I terminate script execution?
I#M not inserting or updating anything in that schema. No use of global temporary tables. Why does a long running query create any redo/undo or what else? Are there hidden 'temporay tables' ?
May
2
comment What does TOAD do, when I terminate script execution?
What is to rollback, when the only statement was a complex select statement?
Apr
30
comment Which is the most performant way to copy a number of SQL Server tables to a readonly SQLite database?
There is no bulkcopy for SQLite
Apr
25
comment MAX for each subset
OK. Nalroff tagged it Oracle.
Apr
25
comment MAX for each subset
And at first I was tempted to propose to migrate the question to SO
Apr
22
comment How to convert a Top 1 subquery using outer table alias to Oracle?
Perhaps enhancing Oracle with top (n) would generate less trouble (LOL). I added the example where your pattern doesn't apply.
Apr
21
comment How to convert a Top 1 subquery using outer table alias to Oracle?
There is a small typo: in my SQL Server example the column name is date and it's type is datetime. It helps in 5 of 6 cases of my underlying problem. The remaining case looks like: (SELECT TOP 1 arx.Apo_VK FROM arx WHERE arx.PZN = art.PZN AND arx.Apo_VK <> art.Apo_VK ORDER by Gdat_Preise DESC ) ... from art