SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Capture header from XLSX to table

vpolasa47 hours ago — edited 31 hours ago

I have below table:

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 sample file: movie2.xlsx

I'm looking to capture data as below:

CONTRACT

PRODUCTION

CONTRACT_START_DATE

CONTRACT_END_DATE

PRODUCTION_CODE

ITEM_NUMBER

ITEM_DESC

LIST_PRICE

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

To my knowledge, SQL Loader doesn't support xlsx. I'm working with my developer to convert the xlsx file to csv.

Converting xlsx to csv, we might lose header information.

What is the best approach to capture header information and store data as above expected?

Using:

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production

Windows 10

Added 47 hours ago

8 comments

54 views