LOAD DATA INFILE
I have a Text file that goes like this:
|Invoice_1500|01222014|
|Led TV|300,00|
|Blue Ray Player|90,00|
|ADP|5,00|
|Invoice_1501|01222014|
|Cellphone 225df|30,00|
|Tape cleaner|2,00|
I created 2 tables (invoice_number, Product)
How can I import this text file using LOAD DATA INFILE and create a relationship between the invoice line and the products lines, so I'll be able to know that invoice number 1500 contains 3 products, for exemple.
Subject
Written By
Posted
LOAD DATA INFILE
May 19, 2014 11:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.