Showing posts from September, 2023
> Go to Interactive Grid > Go to Attribute > Go to --> Initialization JavaScript Function function(config) { let $ = apex.jQuery, toolbarData = $.apex.interactiveGrid.copyDefaultToolbar(); toolbarData.push…
> Go to page and Inline css and paste following code .pridelabel { padding-right: 4px; background-color: whitesmoke; border-top: 1px solid #ced4da; border-bottom: 1px solid #ced4da; bord…
Step-1: ===== You Must be Grid Processes Type Change . Type: Execute Code Language: PL/SQL DECLARE VREJCAUS NUMBER; BEGIN CASE :APEX$ROW_STATUS WHEN 'C' THEN SELECT NVL (MAX (EMPLOYEE_ID), 0) + 1 …
---> This is data insert without Com_id ---> Create Interactive Report Query : select ID, TYPE, NAME, decode(STATUS,1,'Active',0, 'Deactive')STATUS, get_company_dtl('N',COM_ID) COMPANY, …
The CHR() function is used to insert control characters into a string. 1) CHR(10) is used to insert line breaks, 2) CHR(9) is for tabs 3) CHR(13) is for carriage returns. SELECT 'Notify Party '||rownum||' : '||GET_PARTY_NAME_ADD( …