Example of creating DB in SQL

Though we spoke about creating databases using syntaxes, oracle provides a GUI to create a database. Below is the screenshot of creating a database – ORACLE, and various parameters involved in creating it. Library database discussed above can be created in same way as below. Below screenshots talk about lots of parameters, but all of them are default values and are considered by oracle itself. If we need to have any different values, we can set it up while creating the DB using UI – Database Configuration Assistant.

Below diagram shows the users HR_USER and SYSTEM_USERS are the two users / schemas with the database ORACLE. Each user will have their own user name and password to login to their database, and their own set of DB objects. Other users of the same DB can be given privilege to access their DB objects, if required.

Below snippet shows how we can see users and their tables in the same database.

Translate »