1.Create a Blank Page
[ ID=501 , Name=fee information ]
2: Creating Region
Page Rendering> Region{ Create}>form>Tebular >
* Table> FEE
* Primary Key Value=> PL/SQL Program
DECLARE
L_PRIMARY_KEY NUMBER;
BEGIN
SELECT nvl(MAX(fee_Id),100) + 1
INTO L_PRIMARY_KEY
FROM fee;
RETURN L_PRIMARY_KEY;
END;
3.Trigger for Primary Key Value [ Optional ]
create or replace trigger trg_fee_bi
before insert on fee
for each row
begin
SELECT nvl(MAX(fee_Id),100) + 1 INTO :new.fee_id FROM fee;
end;