Follow the below steps to load data from Excel sheet to Oracle tables. This can be used wile data migration.
Step 1: Put your data in Excel Sheet. Remove column headers.
Step 2: Create Table in Oracle. Take care of Column data types
CREATE TABLE XX_TEST
(EMPLOYEE_NO NUMBER,
ENAME VARCHAR2 (50),
SALARY NUMBER
);
Step 3:
Step 4: Select the XX_TEST table and press on Show Data button.
Yes Pratik We can use external table for this purpose. Details I will put in the next post. :)
ReplyDeleteHow to upload .csv file from windows client to linux server in apps?
ReplyDeleteCurrently i'm trying to develop a shell script to ftp input file(.csv file) from client to server.