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 / ramesh babu v
we can werite the condition in trailing null cols
like
trailing nullcols(sal number(10)check(sal<500));
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In oracle application how do you debug or trace errors?
How to create a purchase order without a requisition?
Tell me how to find the custom directory in front end?
q)what are the validations in sql*loader
In hierarchical structure of a database? we have write query from where we should start?
what are the balancing segments in AR?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
pls send me out bound code of supplers,site,bankiformation code pls as soon as
How is choreography different from orchestration?
What is oracle soa suite and what are its different components?
Are you familiar with internet architecture of oracle apps 11i?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
What is count(*) from po_vendors(any table)?
can we use look up type instead of a pofile option?or valueset?is it possible how?