Hi Shaik,
please find an example below:
sqlldr <username>/<password>@<oracle server> control=import.ctl
content of import.ctl:
load data
infile 'c:\temp\file.csv'
into table <table name>
fields terminated by "," optionally enclosed by '"'
( <col1>, <col2>, <col3>, etc. )
regards,
Peter
------------------------------
Automic Certified Professional/Expert & Broadcom Knight
For AUTOMIC trainings please check
https://www.qskills.de/qs/workshops/automic/------------------------------
Original Message:
Sent: Jul 18, 2024 05:34 AM
From: shaik mahammed ziaullah
Subject: Need to insert the csv data into OracleDB Table
Hi Peter Grundler,
Could you share me some sample examples to automate this request.
Thanks & regards,
Shaik
Original Message:
Sent: Jul 15, 2024 05:25 AM
From: Peter Grundler
Subject: Need to insert the csv data into OracleDB Table
Hi Shaik,
I would use the external tool "SQL Loader".
In order to use Automic mechanisms you could use the following:
- create a JOBS.SQL object
- run PREP_PROCESS_FILE to read the CSV file line-by-line
- from the loop use the SQL command "INSERT INTO"
But this method only allows 32767 lines/rows, so you have to split the CSV input file into multiple parts.
regards,
Peter
------------------------------
Automic Certified Professional/Expert & Broadcom Knight
For AUTOMIC trainings please check https://www.qskills.de/qs/workshops/automic/
Original Message:
Sent: Jul 14, 2024 02:20 AM
From: shaik mahammed ziaullah
Subject: Need to insert the csv data into OracleDB Table
Hi Community,
I need some info regarding the automation to insert the csv file data into the Oracle DB Table and CSV file is placed in AE path. CSV file is having the 12 columns and 100000 rows. Kindly provide the script for this.
Thanks and regards,
Shaik.