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
Discy Latest Questions
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
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;
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
Hi Sir, Good Afternoon,can we create a form where we can pull data from multiple table and can update the data as required and that should reflect to respective tables.