SQL with Oracle 10g XE 2 How to Alter Table
hello guys I will show you how to create student database in oracle database software
thank you so much for watching
don't forget to like share comment and subscribe
code part:
create table studentdb(regno number(10) primary key, name varchar(20), dob date, marks number(10));
desc studentdb;
alter table studentdb drop column marks;
desc studentdb;
alter table studentdb modify regno varchar2(20);
desc studentdb;
alter table studentdb add phoneno number(10);
desc studentdb;
please type commands carefully
if you face any doubt don't feel shy to ask me
thank you so much guys