How to add top scroll bar in interactive grid page in Oracle APEX
Click on page -> CSS -> in inline, add the following: .grid_style .a-GV-w-hdr{ overflow-x: auto !important; } Click on region -> Appearance -> in CSS Classes, enter the class name…
Creating APEX report column an external hyperlink
Identification -> Type: Link Link -> Target -> Type : URL, and URL: #COLUMN_NAME# Link Attribute -> target="_blank" (if you would like it to be open on a separate page)
How to add a top scrollbar in grid edit table in APEX, Oracle
You can add a class called "custom_grid" to the Interactive Report Go to Grid Edit Region -> Appearance -> CSS Classes -> Add custom_grid in CSS Classes boxGo to Page…
How to add/drop unique constraint to an oracle table
How to add a constraint (in this case unique constraint) to an existing table ALTER TABLE mytable ADD CONSTRAINT user_role_uq UNIQUE (name, role); How to remove a constraint from an…
How to add column scrollbar on top in report, Oracle APEX
The scrollbar is located at the bottom of the report by default. You can add a top scrollbar for better usability. Click on the Page in CSS --> inline, add…
oracle apex: item with default value created with sql
Assigning a default value to an apex item can be tricky especially when you want to use sql expression. I often get confused whether to use just sql express or…
How to add a default value in Oracle APEX
For APP_USER Create a form pageGo to the item you wish to add APP_USER as a default valuein Default, select Expression (PL/SQL)in the blank line, add :APP_USER For Current Date…
How to create vertical individual report view
Create a Classic Report Region in a Page with a sql querying one rowIn the Classic Report Region, go to Attributes tabIn Appearance -> Template, select Value Attribute Pairs -…
APEX and Google map API Issue
it can get messy when mixing an apex plug in with the google map api. The recent error I had was due to the change of the server domain and…