Dear Vinish, I want to export the data into CSV. but my column name is fixed it may change from time to time in that scenario how to write the procedure to pull the data into CSV with the DB header as it is? Could you please guide me on this?
Discy Latest Questions
SwarupProfessional
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
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.