In one flat file i got headers and lines data how you can write control file now ?

Answer Posted / ramesh

load(skip=1)
data
infile
.....
This command removes the header data. It just inserts the lines data into staging tables

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the benefits of using soa architecture?

709


Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?

1684


what is the differences between internal requisition and internal sales order?

2153


If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

1651


How can you achieve loose coupling in soa framework?

717






How can we import the data into a database using sql * loader?

678


pls send me out bound code of supplers,site,bankiformation code pls as soon as

1754


What is oracle soa suite and what are its different components?

643


Explain what are the tables of auto invoice?

647


testing tools?

1750


Can you explain the difference between architecture followed in 10g & 11g?

656


In hierarchical structure of a database? we have write query from where we should start?

1701


Do you know what is applysys in oracle application database schema, what is apps?

674


What is sca and how is it useful?

658


How to move the one file from one instance to another instance? And your scripts also?

615