Hi! I want to display column “Last User Login” to IR(on that report I use database table) and display date and time for this column. Is there an apex table to track user logins? If exist, could I display this column on existing IR? Thanks in advance!
vinish.ai Latest Questions
Hi, I have a pdf file(blob) that contains 250 pages, that is stored in Oracle table and I want to split that pdf into 250 pages (single single page) using plsql code. please provide me the plsql code. Thanks!!!
Good Afternoon, How to create an Interactive Grid on a table with Checkbox column for Y or N? For example, we have a column in a table called Competed and would like to show this as a Checkbox in IG and would like to save as Y or N in the table. Your help and support would be appreciated. Kind Regards
Is it possible to have a Master Detail Interactive Grid using a View with Instead of Triggers so that in the Master I have records with INTERFACE_TYPE_CODE = 1 and in the Detail I have INTERFACE_TYPE_CODE = 2. For example I have MASTER based on Select TABLE_SK, VALUE_SK, ACTIVE_FLAG , INTERFACE_TYPE_CODE, TABLE_NAME from LOOKUP_TABLE_V where INTERFACE_TYPE_CODE = 1 Detail based on Select TABLE_SK, VALUE_SK, ...
Hi! I use List Of Value with shuttle, to assign user roles. I want to display roles hierarchically, for instance, when user who is logged in, has an Admin role this user should be able to see all roles and assignee them to selected user from LOV item. When user have Moderator role, then should be able to see users who are ...
hi, can you help how to do this. add multi row in oracle apex IG with defual values for some items. For example: Static region with deptno item when you select on of the departments lets say deptno = 5 you will add multiple rows in employee region taking the value from the static region 5 for the deptno. thanks
How to update a database table column using ajax call back process. I have a an interactive grid on a table A and when records in table A are updated the process should get user confirmation and update table B if user confirms by pressing ok. I have created a customer button for Update. I have a hidden data item which ...
Hi! I’m trying to update flag column when dialog is closed, column is 1 or 0 when column is 1 it means that another user edit record (pessimistic locking). I tried with dynamic action, event: dialog closed, which is JavaScript expression contain “window”, true action is pl/sql code. But, it wont update column 🙁 I hope I explained problem well. Thanks in advance!
How can I develop applications using Google Cloud Vision API Document Text Detection in Oracle Apex?
In order to free up screen real estate, I’m considering using a collapsable region. When I do, all the block is “hidden”. If I had a Master-Detail form, how could create a dynamic action to display a different block with only some of the Master, the key fields, and then expand the display the Details block? For example, Sales Order ...