Can use SQL statements TXT file from the FTP and realize the library?

CodePudding user response:

ORACLE has a utl_file package, can achieve read TXT file,

CodePudding user response:

You search the Internet, there are a lot of ready-made script can be reference,

CodePudding user response:

With the shell to remove FTP and SQLLDR realize file transfer and storage

CodePudding user response:

reference minsic78 reply: 3/f

using FTP and shell removed SQLLDR realize file transfer and storage

This method is of higher efficiency!

CodePudding user response:

reference 4 floor jdsnhan response:

Quote: reference minsic78 reply: 3/f

Using FTP and shell removed SQLLDR realize file transfer and storage

This method is of higher efficiency!

Well, it is widely used, if the file is very big, use utl package, performance plummeted,

CodePudding user response:

Should do different things in different tool
You this requirement, written in python is an external script is very simple, if not, learn to look in the future there will be many USES
Or find a colleague to help or