I have a table as below:
CREATE TABLE movie_det
(
contract VARCHAR2(100),
production VARCHAR2(100),
contract_start_date VARCHAR2(100),
contract_end_date VARCHAR2(100),
production_code VARCHAR2(100),
item_number VARCHAR2(100),
item_desc VARCHAR2(100),
list_price VARCHAR2(100),
l1 VARCHAR2(100),
l2 VARCHAR2(100),
l3 VARCHAR2(100)
);
I have xlsx file as below (first row is header):
MOVIE PRICE LIST
Contract #: XY-PR-43278
Production: DREAMWORKS CORPORATION
Genre: DRAMA, ACTION
Contract Dates: July 21, 2026 - May 20 2027
Production Code: D45002
ITEM NUMBER
ITEM DESCRIPTION
LIST PRICE
L1
L2
L3
ITEM-1
DESC -1
$1.00
$2.00
$3.00
$4.00
ITEM-2
DESC -2
$2.00
$4.00
$6.00
$8.00
I'm looking to capture data including the header details as below:
CONTRACT
PRODUCTION
CONTRACT_START_DATE
CONTRACT_END_DATE
PRODUCTION_CODE
ITEM_NUMBER
ITEM_DESC
LIST_PRICE
L1
L2
L3
XY-PR-43278
DREAMWORKS CORPORATION
July 21, 2026
May 20 2027
D45002
ITEM-1
DESC-1
$1.00
$2.00
$3.00
$4.00
XY-PR-43278
DREAMWORKS CORPORATION
July 21, 2026
May 20 2027
D45002
ITEM-2
DESC-2
$2.00
$4.00
$6.00
$8.00
As I understand, Oracle doesn't support xlsx through SQL Loader. I'm working with my developer to convert xlsx to csv.
What is the best approach to capture data as above (include header information)?
Using:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Windows 10