• One thing to remember about Oracle and SQL Server, they are not the same. The internals are different, and there for how the operate is different.

    For example, the following will work fine in SQL Server but will fail in Oracle:

    select current_timestamp

    To get that SQL to run in Oracle it needs to be written as this:

    select current_timestamp from dual

    I'll leave it to you to find out what dual is in Oracle.