Java – how to create a new database in Oracle 11g Express Edition?

I am a novice in Java. I have installed Oracle Database 11g Express Edition and SQL developer

How to create a new database after initially installing Oracle Database 11g Express Edition?, But there are some differences,

I want to know how to use java to create a new database, retrieve data and display data

I want to know, just like PHP and phpMyAdmin And I'm confused with Oracle documents

Please help me Thank you first

Solution

Before creating a database, you must create users who can connect to the database to perform this operation:

connect system/password;

The password you entered during installation

Create user:

create user user1 identified by 'password';

It also provides the user with some permissions to create tables, views, etc

grant dba,resource,connect to user;

After that, you must connect to the user by typing:

connect user1/password;

You can now create a table as follows:

create table exemple(
id int primary key,name varchar2(255)
);