INBOUND INTERFACE: Suppose I have 100 Records of employees
in flat file.When moving the records from flat file to
STAGING table using .CTl file, I want to restrict the
records whose salary is less than 500.what are the
validations(or conditions) you write to achieve this.
Answers were Sorted based on User's Feedback
Answer / basha
we can apply the condotion by using 'when sal<500' before
columns name and after the into statemnt
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / prasanna
WHILE DEVELOPING THE xml format rtf you can make condition
on the field using choose element
| Is This Answer Correct ? | 1 Yes | 1 No |
Do you know where we can check the status of po?
Can you define an erp system?
How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?
tell my any difficult situtation you solved in your experience in your company?
can u explain which situation automonus transaction is used
How many typres of Purchase order and what are those.
what is the purpose of standard cost update?
What is implicity cursor . When it fires . For which statement it will fire(Insert/update/delte). What is the attribute of implicity and explicity cursor oracle 9i. What is the Rec cursor.
What do you understand by a set of books?
What do you understand by concurrent programs?
What is cursor?
Types of cursors?