Showing posts from January, 2025
User Name: Kamrul Department: NULL Designation: NULL You Must be used a Parameter when condition this--> AND (:P22035_DEPARTMENT IS NULL OR DEPT =:P22035_DEPARTMENT) AND (:P22035_DESIGNATION IS NULL OR DESIG =:P22035_DESIGNATION)
create or replace function GET_EXPENSE_DTL (in_type in varchar2,in_id in number) return varchar2 is v_name varchar2(256); begin if in_type = 'AMOUNT' then SELECT SUM(AMOUNT) AMOUNT INTO V_NAME from EXPENSE_DTL where EXPENSE_MST_…
Go to the Link and Download. https://apex.oracle.com/pls/apex/f?p=64237:30 Go to Shared Components --> Plug-ins --> Create--> (Put the Download file) Create a new button and create a Dynamic action using the button. Action: Alertify [Plug-…
In the last section, you want to generate a row in the Grid region. So you can follow the steps. Go to Function and Global Variable Declaration : function f_add_row_last () { var row$ ; var region = apex . region ( 'tots' ); …
