create table movie
(
    Mv_no number (5),
    title varchar2(25),
    type varchar2(10),
    star varchar2(25),
    price number(8,2)
);
insert into movie values('1','Hera pheri','Comedy','Paresh raval',105);
insert into movie  values('2','Kuch kuch hota hain','Comedy','Paresh raval',105);
insert into movie  values('3','Drashyam','Comedy','Paresh raval',105);
insert into movie  values('4','Welcome','Comedy','Paresh raval',105);
insert into movie  values('5','Gupt','Comedy','Paresh raval',105);
insert into movie  values('6','Tere naam','Comedy','Paresh raval',105);
insert into movie  values('7','Hungama','Comedy','Paresh raval',105);
insert into movie  values('8','Ajanabee','Comedy','Paresh raval',105);
insert into movie  values('9','No entry','Comedy','Paresh raval',105);
insert into movie  values('10','Singham','Comedy','Paresh raval',105);
select * from movie;