Skip to Main Content

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!

sql loader help

Ricky007Aug 1 2020 — edited Aug 16 2020

Dear Experts

Please help me load falt file into sql loader with non static column field .

create table tb_accessories

(

col1 varchar2(2000),

col2 varchar2(2000),

col3 varchar2(2000),

col4 varchar2(2000)

);

col1="printer@gmail" col2="printername"

col1="desktop@gmail"  col2="desktopname"

col1="laptop@gmail" col2="laptopname" col3="laptopaddress"

col1="phone@" col2="phonename" col3="phonesize" col4="phoneowner"

This post has been answered by Saubhik Banerjee on Aug 1 2020
Jump to Answer
Comments
Post Details
Added on Aug 1 2020
3 comments
314 views