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

Apex-Item: Radio Group

1.1: Item Property:

https://www.youtube.com/watch?v=zXJvjEdne1I


1.2: Dynamically from Table

http://oracledba.bigresource.com/Application-Express-How-to-create-radio-groups-dynamically-based-on-records-in-a-table-HkG7m3gKp.html

Apex-Item: Check Box

http://isu.ifmo.ru/docs/htmldb_22/appdev.22/b28839/check_box.htm