Hi! I need help with the process of uploading a .CSV to a remote server of the company using SQL*Plus.
Here is what I have until now:
SET pagesize 50000
SET trimspool ON
SET feedback OFF
SET heading OFF
SET echo OFF
SET colsep '|'
SPOOL C:\temp\test.csv
SELECT MMUKID, MMITM, MMMCU, MMDSC1
FROM testdta.F3411;
SPOOL OFF
SET echo ON
SET heading ON
SET feedback ON
The spool generates the csv correctly but I couldn´t find a code to upload that csv to the FTP server.
Any help will be appreciated.
Thanks in advance.