mysql - Create Tables belonging to different problems with same name in oracle -

i have been involved in mysql programming bit. there can create separate databases under same user different projects.e.g.(college database, hospital database) how can achieve in oracle sql? , want command line solution.i.e. sqlplus. problem appearing in sqlplus once 2 tables of different databases appear having same name, error delivered. have different environment each project under same user alone?

it might bit confusing start oracle rdbms when got used mysql world. user in mysql doesn't own db objects: tables/views/etc, db objects belong database. in oracle objects belong schemes (synonym user, showing user owns db objects).

i want show different approaches in mysql , in oracle same tasks:

set current database (mysql)/ set current schema (oracle)

mysql:

use db_name; 

oracle:

alter session set current_schema = schema_name; 

create qualified table:

mysql:

create table db_name.table_name ... 

oracle:

create table schema_name.table_name ... 

select another's db/schema table

mysql:

select * database_name.table_name ... 

oracle:

select * user_owning_table.table_name ... 

so want create oracle schema (let's call "hospital") new project:

create user hospital identified "<password>";  create table hospital.employee( ... ); create table college.employee ( ... );  grant select, insert, update, delete on hospital.employee human_user; grant select, insert, update, delete on college.employee human_user;  sqlplus human_user@your_tnsnames_alias sql> insert hospital.employee(...) values(...); sql> insert college.employee(...) values(...);