Friday, February 3, 2017

serialno auto genetate in oracle forms




 declare 
a number;
begin
a:=1;
while :empno is not null loop
:sno:=a;
a:=a+1;
next_record;

end loop;
end;

No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...