I am trying to work through some of the examples at SQLZOO. I would like to load the AdventureWorks example database into an Oracle database at home. Google search has not turned up any SQL scripts that have been converted for Oracle. Does anyone have or know where I can get such scripts?
T-SQL and PL/SQL have variations in syntax and the concept of a database within a database is called a schema of a database in Oracle.
Oracle does supply some sample schemas that one can use for playing around, see Database Sample Schemas
You can load the data of AdventureWorks once you have sorted out the table and associated schema creation using
bcp out and
bcp in or using SSIS. See bcp Utility in the Microsoft documentation.
Cautionary note about the SQL Developer Migration Tool: It will create a SQL Package called
SQLSERVER_UTILITIES (if I recall correctly), which contains a load of functions that mimic some SQL Server keyword functionality that doesn't exist with the same name in Oracle, and some of these functions are horribly inefficient.
If you use the Migration Tool then it is worth making sure that what you end up with doesn't use this package but instead uses the native PL/SQL commands. Trust me, I've been there and felt the pain!
I created a data set two years ago for an article I wrote for the Oracle Technology Network on Essbase Studio.
You can find the code, DDL and DML in Oracle Essbase Sample Code
The download in the list you want is for Sample application accompanying the OTN tech article, "Oracle Essbase Studio Deep-Dive" (
I really wouldn't try to convert the AdventureWorks data for use in Oracle.
Oracle has its own demo data, which can be loaded using the scripts in
$ORACLE_HOME/demo/schema. These are documented in Oracle® Database
Sample Schemas 11g Release 1 (11.1) (pdf).
Rather than sticking to the SQLZOO examples, you'd be better off starting with an Oracle-based SQL tutorial that uses the Oracle demo schemas, such as Oracle/SQL Tutorial (pdf) by Michael Gertz (assuming that your aim is to learn SQL).
An idea . . . . Use a data modeler tool ! A) Import SQL Server Physical Data Model ( PDM ) B) Reverse engineer it, to get Logical Data Model (LDM ) c) Forward engineer it to Oracle ( PDM )
There you go