Queries-for-schema-table-creation.txt

---- SCHEMA CREATION
ALTER SESSION SET "_ORACLE_SCRIPT" = TRUE;

CREATE USER SWIGGY IDENTIFIED BY SWIGGY;

GRANT CREATE SESSION TO SWIGGY; --HR is the password

GRANT CREATE TABLE TO SWIGGY;

GRANT CREATE PROCEDURE TO SWIGGY;

GRANT UNLIMITED TABLESPACE TO SWIGGY;

GRANT CREATE VIEW TO SWIGGY;

----- import all the dataset into this schema
DATABASE : Oracle SQL Developer
Right click on table -> import -> select the csv