Saturday, March 14, 2015

APEX-Tabula Form: Using built-In Wizard




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;

No comments:

Post a Comment