Create Table space and users in Oracle

-- Create Table space mytest

Create tablespace mytest

Datafile '/u01/APP/Oracle/oradata/healthybox/mytest01.dbf' size 200 m
Extent management local;

-- Create user Tester
Create user tester identified by Tester
Default tablespace mytest;

-- Assign the following Permissions

Grant connect, DBA to Tester;

Grant exp_full_database, imp_full_database, resource, create any sequence to Tester;

Grant create any trigger, create any view, create table, drop any view to Tester;

Grant exp_full_database, imp_full_database, resource, create any sequence to Tester;

-- Create an auto-increment Field

Create sequence studentid_sequence -- create a sequence named userid_sequence
Increment by 1 -- auto-increment by 1 each time
Start with 1 -- auto-increment from 1
Nomaxvalue -- no maximum value
Nocycle -- non-circular

Insert into student (ID, stdname, stdnum) values (studentid_sequence.nextval, 'ruby', 22 );

-- It can also be written in the trigger to implement