Home » SQL & PL/SQL » SQL & PL/SQL » insert data from csv file (oracle 19c, windows 11)
insert data from csv file [message #689809] Mon, 29 April 2024 02:39 Go to next message
jimut
Messages: 1
Registered: April 2024
Junior Member
I need to write a generic procedure where I will pass the CSV file name with path as a parameter and this procedure will insert data into the table.

Report message to a moderator

Re: insert data from csv file [message #689810 is a reply to message #689809] Mon, 29 April 2024 03:59 Go to previous messageGo to next message
cookiemonster
Messages: 13923
Registered: September 2008
Location: Rainy Manchester
Senior Member
have a look at external tables.

Report message to a moderator

Re: insert data from csv file [message #689811 is a reply to message #689810] Mon, 29 April 2024 04:11 Go to previous message
Barbara Boehmer
Messages: 9094
Registered: November 2002
Location: California, USA
Senior Member
You might also try SQL*Loader Express:

https://docs.oracle.com/en/database/oracle/oracle-database/19/sutil/oracle-sql-loader-express-mode.html

Report message to a moderator

Previous Topic: Missing records
Next Topic: PL SQL table generate auto index
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 01:23:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.