Hi
i would like to display result as below.
drop table test5;
create table test5(tno number);
begin
for i in 1..10 loop
if i in (4,7,8) then
null;
else
insert into test5 values(i);
end if;
end loop;
commit;
end;
select * from test5;
required result.
tno, rankVal
1 1
2 2
3 3
5 1
6 2
9 1
10 2