select * from tab
create table Akstudent(
                       sname char(20),
                       Rollno number(6),
                       Regno number(6),
                       contact number(10));
desc akstudent
alter table Akstudent add(Address varchar(100));
alter table Akstudent add(Email_id varchar(100));
alter table Akstudent add(Address1 varchar(100));
alter table Akstudent drop column Address1;
alter table Akstudent drop column Emailid;
alter table Akstudent modify(sname varchar(30));
insert into Akstudent values('Akash1','306267','141140','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash2','306268','141141','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash3','306269','141142','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash4','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash5','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash6','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash7','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash8','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash9','306270','141143','8149771771','shubhashri colony n6','[email protected]');
insert into Akstudent values('Akash10','306270','141143','8149771771','shubhashri colony n6','[email protected]');
select * from Akstudent
update Akstudent set sname='Akash Katare' where sname='Akash';
select * from Akstudent where regno between 141140 and 141141;