How to set Session Time Zone In Oracle Apex
Create a PL/SQL Process PL/SQL Code
|
1 2 |
APEX_UTIL.SET_SESSION_TIME_ZONE ( P_TIME_ZONE => :P1_SET_TIME_ZONE); |
Thank You
How to Refresh Report on modal dialog window closed in Oracle Apex
Create a Dynamic Action Named “Refresh Report” Event = Dialog Closed Selection Type = JavaScript Expression Client-Side Condition > JavaScript Expression
|
1 |
window |
Add a True Action Action = Refresh Selection Type = Region Region = Employee List (set your own region here) Apply Changes and run the page. you will …
Custom Success Message using Dynamic action in Oracle Apex
Create a Dynamic Action Create a True Action Action = Execute JavaScript Code Code =
|
1 |
apex.message.showPageSuccess('Action Processed.'); |
Thank You
How to get Screen Resolution of system in Oracle Apex
Create 2 Text Items P1_SCREEN_WIDTH P1_SCREEN_HEIGHT 2. Create a Dynamic Action Named “get Screen Resolution” Event = Page Load True Action = Set Value Set Type = JavaScript Expression JavaScript Expression =
|
1 |
window.screen.availWidth |
Affected Elements > Selection Type : Item(s) Item(s): P1_SCREEN_WIDTH Fire on Initialization :Yes Create another True action under …
How to force Upper case text in a text field In Oracle Apex
Go to the Item Property Advanced > Custom Attributes Type the below Code:
|
1 |
style="text-transform:uppercase" |
for Lower Case:
|
1 |
style="text-transform:lowercase" |
when you save and run the page, you will see what ever the user types, inline it will be auto converted to upper case. Thank You
How to show mouse over tool tip of a item in Oracle Apex
Go to the item property Advanced > Custom Attributes Type the below code:
|
1 |
onmouseover="toolTip_enable(event,this,'Employee Name')" ; |
When you put mouse on “Employee Name” text field ( as example) it will show the tool tip ‘Employee Name’ Thank You
How to Redirect page In Oracle Apex
Create a Page Process as shown below: Name: Redirect Page Source PL/SQL Code:
|
1 2 3 4 5 6 7 |
DECLARE v_redirect_url VARCHAR2(100) := 'f?p=102:101'; BEGIN htp.init(); owa_util.redirect_url(v_redirect_url); apex_application.g_unrecoverable_error := true; END; |
Execution Options > Point > Before Header Sequence : 1 When this page will be called, automatically before loading this calling page, it will be redirect to the page 101. you can set your own destination …
How to add link button in the post text position of a item in Oracle Apex
Go to Item Property > Advanced > Post Text: Type the below code if you want to put a hyper link button named “lookup”
|
1 |
<a href="f?p=&APP_ID.:83:&APP_SESSION.:::83::">Lookup</a> |
Here 83 = page number ( put your own page number) Save and Run the page, when you click lookup hyper link it will take …
How to Launch inline dialog in oracle apex using JavaScript
How to show and hide inline dialog in oracle apex using JavaScript Create a Region named as example “Employee Details: Assign a Static ID of the region “EMPDTLS” ( ..Region Property/Advanced/Static ID:) Create a Page Button Named “ShowDialog” Go to the button property and set it’s properties as below: Behavior/Action …