Can a Oracle external table go to a client machine and grab data saved in a excel csv file?
I need to develop a pl/sql stored procedure to load a csv file from a client side to a external table on the server side. I think I need to develop this procedure since I think Oracle external table which must be placed in the server side canot go directly goes to user machine and grab data from a csv file saved in user's directory. I don't know how to go to develop such a procedure and need help started. Thanks