Hi everyone, I created wizard page to Order Item in my application, i used classic report to show all items with Amount and allow user to enter Quantity using apex_item.select_list( 0,1) . Here i want to show Sum of Amount of items which has Qty = 1. Any help would be highly appreciated...
Discy Latest Questions
Hi everyone, I'm using Apex collection to store data , manipulate it and insert to target table. In Apex collection there are only 5 number columns , what if i need more than 5 number columns in my collection? Any help would be highly appreciated..
Hi everyone, I created manual data loading using PL/SQL parser to parse data and pl/sql process to insert that data into table, The data gets parsed just fine but how can i add this data to collection? Any help would be highly appreciated...
Hi everyone, I'm using APEX 21.1, I created an upload page using PL/SQL Parser to parse data and created a process to load it into the target table. here i need validate the data in excel sheet before insert data into target table and show error log in the same page when user clicks to upload button. How to validate and show error log. Any help would be highly appreciated...
Hi everyone, How to insert multiple values into single column using insert into statement? For example, i have booking say ID = B1, i made 2 issue against Booking Id = B1, say issue numbers are Is1, Is2 now while Invoicing, Invoice No = In1 , i have to store Issue Numbers(both Is1 & Is2) against the Booking ID =B1 in invoice . Any help would be highly appreciated..
VARSHAProfessional
How to specify "Session Timeout URL" or "Idle Timeout URL" as "LOGOUT_URL" in APEX 20.2 The documentation states that: "Only three substitution items are supported in this URL: &APP_SESSION., &SESSION., and &APP_ID., although because of the particular purpose of this URL it is not necessary to include either &APP_SESSION. or &SESSION. in the link." The one I am most interested in would be the "LOGOUT_URL" . Any help would be highly appreciated..
VARSHAProfessional
Hi everyone, I'm using APEX 20.2, I have a classic report for Ordering Items with Item, Rate, Quantity (select list column with values upto 5 and null value 0) and Amount column, The question is how to make the summation of Amount for only the Quantity > 0? the summary should change while selecting Quantity. Any help would be highly appreciated..
VARSHAProfessional
Hi everyone, I'm using APEX 20.2 , I have classic report with Items to order where i used checkbox column(APEX_ITEM.CHECKBOX2) to select required items. after selecting i have to move the selected rows into collection when click on button, how to get the selected rows into collection. what is the default checked / Unchecked values of APEX_ITEM.CHECKBOX2? Any help would be highly appreciated.. but when i click on button after selecting rows , the selected rows are not moving to collection
Hi everyone, I'm using APEx 20.2 I want to create multi-column POPup LOV with where clause based on page item value How to do this? Any help would be highly appreciated...
Hi everyone, I'm using APEX 20.2, I want to copy tables including triggers, constraint, sequence, index from one schema to another schema in same workspace. How to do this? Any help would be highly appreciated..