Import/Entry from txt file [message #675557] |
Sat, 06 April 2019 04:13 |
|
Salehin
Messages: 62 Registered: March 2013 Location: Chittagong, Bangladesh
|
Member |
|
|
Hi everyone,
When I face any difficulties in orcale every time I find solution from this forum. May God bless you.
I want to input data from Excel to my Sql. I am using Data Load for this but I think there may be an alternate/Easy way to input with Sql command. here is my table.
SQL> desc ITEM_MASTER;
Name Null? Type
------------------------------- -------- ----
ITEM_CODE VARCHAR2(50)
ITEM_NAME VARCHAR2(500)
MASTER_CODE VARCHAR2(50)
ITEM_MASTER VARCHAR2(100)
GROUP_CODE VARCHAR2(50)
ITEM_GROUP VARCHAR2(100)
ACC_NAME VARCHAR2(100)
TYPE_CODE VARCHAR2(10)
TYPE_DESC VARCHAR2(150)
UNDER_CODE VARCHAR2(10)
UNDER_DESC VARCHAR2(150)
APP_CODE VARCHAR2(10)
APP_DESC VARCHAR2(150)
I am attached my txt file.
Sorry in advance If I do any fault against COC.
*BlackSwan corrected {codetag}
[Updated on: Sat, 06 April 2019 06:07] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
|