Hi, Good Evening, I want to pull data in CSV format and I have written plsql procedure for that and I am able to export the data successfully but there is a concern that if a data contains a double quote then it's getting disappear in CSV export but I need that double to be there in data, Please find the screenshot of plsql procedure for your refernce For eg: i have entered data as "NAME" I need this in CSV format also Can anyone please help me out? Thanks in Advance
Discy Latest Questions
SwarupProfessional
Dear Sir, Good Evening, Can we restrict data entry after one record is created? Ex:An end-user has created one record but he/she shouldn't be able to enter a second record into the application/DB Thanks in Advance
SwarupProfessional
Hello Sir, I want to get the data for example if data is present in the description then data should come else NA should appear. <?if:Description2=' '?> NA <?end if?><?if:Description2='Description2'?> Description2 <?end if?>
Hi Sir, Good Evening, Happy New Year, I have installed Oracle Apex in One Database(Development DB) but i want to get the data from the another Database(Validation DB) where apex is not installed is it possible? Thanks In Advance
Hi Sir, Good Morning,i want to insert the app user in to the data table for eg: i am entering data into table ID: Project: Task: App_user: if i am the user then i have logined to application the application user name should be insert into the app_user
SwarupProfessional
Hi Sir, Can we show a sub region on top of the IR which will show the time(total hour) and the week( from 02-06)
SwarupProfessional
Hi Sir, I have created a lov with Approve All,Reject All. If i select approve all then all the status field should be approved vice versa dynamically
SwarupProfessional
Hi Sir, Good Morning,i have two tables table1 and table2 when field status of table1 is approved then it should insert into table2 i have used this trigger but not firing create or replace TRIGGER TRG_Times_INSERT AFTER INSERT ON Times FOR EACH ROW BEGIN IF :NEW.STATUS = 'APPROVED' then INSERT INTO APPROVE (PID,BILLING_STATUS,TASKS,MONDAY,LOGM,NOTEM,TUESDAY,LOGT,NOTET,WEDNESDAY,LOGW,NOTEW,THRUSDAY,LOGTH,NOTETH,FRIDAY,LOGF,NOTEF,TOTALHOURS,STATUS,COMMENTS) VALUES (:NEW.PID,:NEW.BILLING_STATUS,:NEW.TASKS,:NEW.MONDAY,:NEW.LOGM,:NEW.NOTEM,:NEW.TUESDAY,:NEW.LOGT,:NEW.NOTET,:NEW.WEDNESDAY,:NEW.LOGW,:NEW.NOTEW, :NEW.THRUSDAY,:NEW.LOGTH,:NEW.NOTETH,:NEW.FRIDAY,:NEW.LOGF,:NEW.NOTEF,:NEW.TOTALHOURS,:NEW.STATUS,:NEW.COMMENTS); END IF; END TRG_Times_INSERT;
SwarupProfessional
Hi Sir, Good Afternoon,Sir Can you please guide me how to capture only time in apex and what will be the datatype in db and any configuration in frontend.
SwarupProfessional
Hi Sir, i want to add fields,eg:there are 5 fields where if i enter 3 fields also the value should be calculated,and the number that i am entering is like 2:00,0:30 but i am unable to sum all the fields if i am entering like this able to do sum:2+3+5 using PLSQL Expression (:P6_LOGM+:P6_LOGT+:P6_LOGW+:P6_LOGTH+:P6_LOGF) unable to do sum 2:00+3:00+5:00