WHAT IS THE USE OF SKIP WHERE U WILL GIVE?

Question Posted / askvenki

3 Answers
7109 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?..

Answer / kumar

It is used in SQL Loader

At the begining of control file

(OPTIONS SKIP=10)

or
U can set it in command line also

SKIP gives the information to SQL Loader not to load first
10 lines.

Is This Answer Correct ?

4 Yes

0 No

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?..

Answer / sri

yes it skips the first records depending upon size that is
given in skip command

Is This Answer Correct ?

3 Yes

0 No

WHAT IS THE USE OF SKIP WHERE U WILL GIVE?..

Answer / hari

TO SKIP THE NUMBER OF RECORDS
LOAD DATA
SKIP n or at command prompt

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Apps Technical Interview Questions

How relation will be made between modules in oracle financial?

4 Answers HCL, Wipro,

what is difference between po_headers_all and po_headers

5 Answers Deloitte, Wipro,

How will you get the concurrent program output as email?

3 Answers IBM, KPIT,

Difference between set of books id and ledger id in r12 ?

1 Answers TCS,

do i need to declare bind parameter before using in the query?

2 Answers Satyam,

can we write multiple procedures in package with same name like A p1,p2(parameters) B p1,p2(same parameters)

4 Answers

how to move the one file from one instance to another instance?and ur scripts also?

1 Answers KPMG,

How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers KPIT,

How to create a link between One dependent value set to another Dependent value set

5 Answers Indorama, ManSoft System, Syntel, TE Data,

What is a flexfield? List out its types.

0 Answers

what is the database size you used?

1 Answers FIS,

For more Oracle Apps Technical Interview Questions Click Here