Desc Plan;
Name Null? Type
PID NUMBER
PLANNAME VARCHAR2(20)
USAGERATESLABS NUMBER
USAGE NUMBER
Datatest.xlsx
PID PlanName UsageRateSlabs Usage
1 PlanA 10000,0.25|10000,0.20|10000,0.15|99999,0.10 33000
2 PlanB 5000,0.30|10000,0.25|15000,0.20|25000,0.15|99999,0.10 33000
3 PlanC 5000,0.25|10000,0.20|99999,0.15 33000
When I tried to load data Using the following SQL Query, It executed successfully but the data is not loaded into Table.
load data
infile 'D:\DataTest.xlsx'
insert into table Plan
fields terminated by ','
Optionally enclosed by ' '
(PID,planName,usagerateslabs,usage)
Can Anyone Please Correct Me! Please You can Correct me by writing correct query, please!