APEX-5 : Coloring Cells in an Interactive Report

http://mk-commi.blogspot.com/2016/01/coloring-cells-in-interactive-report.html

Oracle SUN SPARC virtualization

     https://blogs.oracle.com/cmt/entry/what_s_up_with_ldoms

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;

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 ]

APEX-Region SQL

Page rendering > Region > create > reports > Classic Reports >

Apex-DML: Manual FORM Style

1.Database Table
----------------------
create table personal_info
(id  number(5),
 pname       varchar2(100),
 gender      varchar2(1),
 married     varchar2(1),
 smoker      varchar2(1),
DOB         date,
country     varchar2(100)
);

2.Create a bank page / Create a HTML Region / Create below Items
----------------------------------------------------------------------------------
   id    ---pk value
   pname  -- text item
   gender -----list item
    married  ---radio item
    smoker   --- check box
    country  --- pop up list


 3.Sending Data to Database Table=personal_info
--------------------------------------------------------------
    * create a region button names=> ADD < action submit>
    * create a process named=> PRC_ADD
                    < Process Point: On submit : before computation and validation >
                    <Source>


   BEGIN
      Insert into personal_info(id,pname,gender,married,smoker,dob,country)
      values(:P101_ID,:P101_PNAME,:P101_GENDER,:P101_MARRIED,:P101_SMOKER,:P101_DOB,:P101_COUNTRY);

        commit;
  END;






Use Below Reference
----------------------
https://tts.inso.tuwien.ac.at/i/doc/bldapp_frm_manual.htm

Apex-Login:Custom

http://djmein.blogspot.com/2007/07/custom-authentication-authorisation.html


https://docs.oracle.com/cloud/latest/db112/HTMDB/GUID-6441782B-12E4-4465-B2A4-216141A4AAA7.htm#HTMDB12003