in sql *loder how to skip the middle records ex:from 10th to 20th records i want to skip?
Answers were Sorted based on User's Feedback
Answer / kutti
FILLER IS Used to SKIP the ENTIRE COLUMN not the DATA in the column.
Is This Answer Correct ? | 15 Yes | 4 No |
Answer / bhargav
by using FILLER
instead of column name if we use Filler we can skip the records
Is This Answer Correct ? | 5 Yes | 18 No |
where we can check the status of po.
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
what is organization id
In a Standard form a DFF is disable?How we can Enable it?
What are the Major differences between appcore.pll and appcore2.pll
4 Answers Infosys, Sierra Atlantica,
how many groups we can create for query?
wht is format triger?
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.
Do you know what is applysys in oracle application database schema, what is apps?
If there is any issue then whom do you report.(this is imp question for every interview)
what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?