Dynamic url using APEX Utility

Create dynamic URL on classic report column in Oracle APEX

Sometimes requirement comes to generate hyperlink dynamically based on column value in classic or interactive reports. APEX utility apex_page.get_url or apex_util.prepare_url can be used to build hyperlink inside a SQL statement. select ID,FIRST_NAME ||’...

File Type Validation in Oracle APEX

Sometimes requirements come to check file type before uploading into the application to restrict the unusual file type. Below steps will guide to check file type before uploading into database column and show an...

Keyboard shortcut for Interactive Grid in Oracle APEX

Keyboard shortcut for Interactive Grid in Oracle APEX

In a default set Interactive grid report (IG Report) is having some options like Add Row, Edit Row, Delete Row, Refresh Row etc. Below Javascript code will create keyboard shortcut for each actions available in Interactive...

Issues with input fields apex applications

Issues with input fields apex applications

If you are facing issues with your input fields like text field, text area, select lists then it’s not your application issue, this issue is arising due to the upgradation of chrome browser. All...