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;

Friday, March 13, 2015

Apex-List: For User Home Page



1.Creating List

Application> Shared Component> List >[ Create ]

    * > From Scratch > [ Name: FEE_COLLECTOR  , Type: Static ]

           Label                       page
         --------------------------------
          Fee Name                501
         Course Name           503
         Department              505

2. Attaching Image within List
      Application> Shared Component> List > click on FEE_COLLECTOR

           * > Click on item [ fee Name ] > select image  [  APPLY Change ]


3.Create a Blank Page
          [ ID=500  , Name= User Home Page ]

4.Create a region [ type List ]
        Type=List
        Template=>Horizontal image with label List


5. To Navigated Page [ example:  501= Fee Names ]
    * Create a region BACK Button
                         [  Position: right of the page title ,
                            Action: =Redirect to page
                            Page:  500 ]