Just installed 10g Exp, can I use the "Bank" database from MySQL?
819158Nov 27 2010 — edited Nov 30 2010So I installed MySQL, PHP, and Apache, separately. I was using a "Learning SQL 2005" book that instructed me to create a play "bank" database, and run the code to create/populate tables. I used the bank database for a while to learn and it was great.
Now I installed Oracle Database 10g Express Edition and I uninstalled MySQL, PHP, and Apache. Is it possible to use this bank database that I was using with MySQL?
When I go to the Database Home Page and go into the SQL Commands section and type "use bank;", it says "ORA-00900: invalid SQL statement".
When I type "create database bank;", it says "ORA-01501: CREATE DATABASE failed ORA-01100: database already mounted".
Also, since the SQL statements that I used to create the database in MySQL is just ANSI SQL, I can use these same statements to create a database in Oracle, right?
Thanks for your help!