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.
- 2 Answers
- 7174 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
q)what are the validations in sql*loader
Do you know what is applysys in oracle application database schema, what is apps?
List of all the modules under Manufacturing, Finance and Distribution in oracle applications?
In sequence i want to 11 and 15th values how we will write?
how can develope the po variance and po summary report? with tables mandatory columns and query please?
what is the difference between request group and request security in oracle apps?
Can we create tables in apps schema?
In hierarchical structure of a database? we have write query from where we should start?
do you know is it possible to run the interface without using oracle apps?
Can you define an erp system?
what is pay run id ?
What do you understand by a set of books?
What do you understand by concurrent programs?
what is the differences between internal requisition and internal sales order?
How to create a purchase order without a requisition?
