Showing posts from December, 2022

Checkbox Style Query in Oracle Apex

Step-1 : ===== Create Region. Name : Check Box Type : Static Content Create New Item this Region. Name : P2_DEPARTMENTS Type : CheckBox List Of Values - Type : SQL Query SELECT DEPARTMENT_NAME,DEPARTMENT_ID FROM DEPARTMENTS ORDER BY 1; Create Dyna…

Dynamic Case Calculation

Table Items ======== UNIT  ---- CM(1) , Inch(2) PIECES LENGTH WIDTH HEIGHT CBM VOL_MET_WEIGHT_INC VOL_MET_WEIGHT_CM Unit = CM =======  Length * width * Height * Pieces / 6000 / 166.6667   11      * 24     * 11       * 500   / 6000 / 166.6667   =1.45 C…

User + Role + Dynamic Menu setup

Table ==== 1) CREATE TABLE  "UMS_MENU_MAIN"     ( "ID"                          NUMBER ,  "MENU_NAME"           VARCHAR2(100) NOT NULL ENABLE,  "MENU_TYPE"            VARCHAR2(10),  "RUN_FILE_NAME…

Home Page Module Design

Step-1 : Go to Shared Components --> Lists --> Create (New List Create) Fill up the  List Entry Label     And   Target Page ID or custom URL Step-2 : Go to Home Page And Create Content Body (As Like "Setting Modules" ) --> Title :…

Header Design HTML & CSS

If you want to customise Header on Region. Then At first remove Page title. (if your Page Mode : Modern Dialog) --> select the Region  --> Header text  (copy to paste) <style> h1 { text-align: center;     color: white;} </style> &l…

Cascading List of Values

1. If you want to show data Master table data wise Details table data. Following this steps... Step - 1 :  Go to Shared Components and You must Create List of value. --> SQL Query : select   ID , NAME   from  NOTIFY  where   Buyer_id =:P8_BUYER_ID…

Load More
That is All