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.
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
Do you know where we can check the status of po?
do you know is it possible to run the interface without using oracle apps?
what is the differences between internal requisition and internal sales order?
Tell me how to debug the report?
can we get profile values in report without using user exists is it possible how?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
In support project one ticket alloted which steps follows manualy tell me ?
In hierarchical structure of a database? we have write query from where we should start?
What do you understand by a set of books?
In sequence i want to 11 and 15th values how we will write?
how do you describe O2C along with tables
how to print multi lay outs,muti currency,muti language in xml publisher
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Can we create tables in apps schema?
Do you know what is applysys in oracle application database schema, what is apps?