--create table
create table Table_name(
user_id nvarchar2(10) not null,
user_name nvarchar2(30),
user_group nvarchar2(30),
user_title nvarchar2(30),
option1 nvarchar2(50),
option2 nvarchar2(50),
option3 nvarchar2(50)
);
--setting primary key (default index)
alter table Table_name
add constraint table_name_PKEY primary key (user_id);
--create indexes
create index Table_name_index01 on Table_name (user_name);