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

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...