Oracle Important Scripts

create table tb_external_staff (sl_no number, staff_name varchar2(100), designation varchar2(100), inst_code number, inst_name varchar2(100),
acted_as varchar2(100), session_date date, session_id varchar2(10), x varchar2(100))

alter table tb_external_staff drop column session_date;

alter table tb_external_staff drop column session_id;

 create table tb_external_attend (sl_no number, session_date date, session_id char(2), off varchar2(50));