A Direct Export of MSSQL Northwind sample database to Oracle 19c
This sample database was exported directly from MS SQL to Oracle database 19c. I have dropped invalid objects, modified the PLSQL to fix the views and procedures and as on the time the DDL from 19c was creaetd, there were no invalid objects.
-1. Create a new schema 'NORTHWIND' on tablespace EXAMPLE -2. Use Oracle SQL Developer. Open, inspect and execute to create the objects -3. All the procedures return ref_cursors, adjust your application accordingly or change the procedure for your preferred returned values.
Two SQL files added, one for Oracle database 19c and the other one for 11G
-1. Users with 11G or 12c/18c database should use the NorthWind11G.dmp for importing the schema.