I have 5 columns in table. I m going to collect user inputs in 4 columns and rest 1 column will be sysdate (date+ Time stamp) which user will not view/enter/correct but my form should manage and insert accurate value. How can I do? I have set value in default/source but while inserting it gives error. <dt_created> can not insert null. Pl guide.
Discy Latest Questions
I want to manage stock date by date. For Example if one item comes first it should be gone first. When I issued stock the first date stock should be finished first then other.
I am making a Master Detail forms. The objective of this entry screen to capture questioners from the customers. We have 100 difference questions that customer support to answer. I want to make a Master Detail in such a way that when the users has entered his basic information in the Master Form all the question should reflect in the detail form (get it from Question Master Table) and he just only click /tick the approporaite answer. I have a master table to for all the questions. Table Structure--- Master: record_id number primary key, record_date date, user_ id number ); Detail record_id number references master, question_id number reference question_mst, option_id number); I am new to Oracle APEX though I have morethan 17 year of experience in Oracle Forms/Discoverer and EBS suites. Now trying to explore APEX.