INTERVIEW QUESTIONS
ORACLE APPS
ORACLE FORMS
DETAILS
Question: What is who column and how you set the values?
Answer: Columns tracking the audit trial(user) information. CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN
|
Question:
What is who column and how you set the values?
Answer:
Columns tracking the audit trial(user) information. CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN Source: CoolInterview.com
Who column are those which keep the history of record and these are : CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATED_DATE, LAST_UPDATE_LOGIN and in Forms we have to use API ie. FND_STANDARD.SET_WHO in pre_insert and pre_update trigger to set it as default update for all the tables where the data is being inserted in table thru form. Source: CoolInterview.com
Answered by: Gyan | Date: 6/21/2010
| Contact Gyan
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|