Hello, I want to write a plsql procedure block to generate a CSV file using manual data as well as data from one table, using utl_file package and cursors. Please check the attachment. The table has records of a few lines only which has data and I want to add time column(column A) as you can see in the attachment where it will have time data after every 5 mins and for any time if a table has records, the procedure has to take the data into the file. Thanks, Bansari
Discy Latest Questions
Hi I want to get client desktop name in oracle apex . I am unable to find solution
Hi sir jii, How to hide Rows in IR Report when column values is null. Can you please suggest.
page item is P73_ACTION_OWNER_01 it is a text field i want to use text which is type in this text field to pass as string in below sql query select Name from EBA_PROJ_ROLES where ID in (select distinct ROLE_ID from EBA_PROJ_USER_REF where USER_ID in ('select ID from EBA_PROJ_STATUS_USERS where FIRST_NAME like' || : P73_ACTION_OWNER_01));
Hi sir jii, How to show the serial number in IR report if the query is in group by format.
Hello, Please help me figure out how I can format text in an Interactive Grid plain text field. I do have a column fetched from a table in an Interactive Grid column. The column in a table is a varchar2 type and has the text of up to 1000 characters. Now the requirement of an Interactive Grid is, that I want to display it in a bullet format if it has multiple sentences separated by '.' Example: Actual: Suzy provides the monthly financial reporting based on provided figures. The shareholders of the store have changed effective November 2021. How I want: Suzy provides the monthly financial reporting based on figures. The shareholders of the store have changed effective November 2021. Note: I have tried the solution by adding "replace(comments, '.', '<br>') comments" in select query in an interactive grid but it isn't working. Many Thanks, Bansari
Hi sir jii, How to right align the aggregated column value in oracle apex
Hi Sir jii, i have the sum of aggregate value for two columns need to calculate the average for these two values can u please suggest.
Hi sir jii, How to display null value as zero in IR report can you please suggest.
I have employee master table and using submaster for department and positions. I want to create an Interactive grid on Employee Master Table , but need to get data from Department and Positions tables based on the department code and position code in employee master table. Actually, I do not want to update multiple tables in the grid. I want to update only 1 Table Employee Master but just want to display data from other tables too using Employee Number to retrieve data from other table. I believe, it must be very simple, but I do not know how to do it. My requirement is just simple as below: Employee Master Table Employee_No Employee_Name Employee_Hire_Date Employee_NO Employee_Name Employee_Hire_Date 1001 ABC 01-JAN-2022 1002 DEFGHHFJ 20-JAN-2022 1003 XYZJHJSJ 25-JAN-2022 Employee Status Table Employee_No Employee_Status Employee_Status_Date Employee_NO Employee_Status Employee_Status_Date 1001 A ...