/******************************
Oracle Solution
******************************/
INSERT INTO Employees
(EmployeeID, LastName, FirstName, Title, TitleOfCourtesy, 
    BirthDate, HireDate, City, Region, 
    PostalCode, Country, HomePhone, ReportsTo)
VALUES(10, 'Dunn', 'Nat', 'Trainer', 'Mr.',
    '01-Feb-1970', '04-Mar-1997', 'Jamesville', 'NY',
    '13078', 'USA', '315-555-5555', '1');

/******************************

SQL Server & MySQL Solution
******************************/
INSERT INTO Employees
(LastName, FirstName, Title, TitleOfCourtesy, 
    BirthDate, HireDate, City, Region, 
    PostalCode, Country, HomePhone, ReportsTo)
VALUES('Dunn', 'Nat', 'Trainer', 'Mr.',
    '1970-02-01', '1997-03-04', 'Jamesville', 'NY',
    '13078', 'USA', '315-555-5555', '1');

/******************************

Oracle Solution
******************************/
INSERT INTO Orders
(OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate)
VALUES(11078, 'COMMI', 10, '24-May-2004', '12-Jul-2005');

/******************************
SQL Server & MySQL Solution
******************************/
INSERT INTO Orders
(CustomerID, EmployeeID, OrderDate, RequiredDate)
VALUES('COMMI', 10, '2005-05-24', '2005-07-12');

INSERT INTO OrderDetails
(OrderID, ProductID, UnitPrice, Quantity, Discount)
VALUES(11078, 3, 10, 100, .1);

/*
    SQL Server users will replace OrderDetails with OrderDetails

*/