This content has been marked as final. Show 3 replies
In your given solution, we are accessing data from wwv_flow_files table. In that solution neither we are defining the file path of the file nor we are uploading the file into the database.
Would you please tell me any step by step solution of the problem? I want only one thing that I wanna move the same data into database table which exists in text or csv file.
Waiting of your reply,
wwv_flow_files is used by APEX to hold uploaded files.
If you incorporate a file browse item on you page, browse for the selected file, then submit the page (having the PL/SQL process described as an on suibmit process) then what I detailed should work.
If you don't need users to have access to this then just go to Home>Utilities>Data Load/Unload in APEX and there is a handy load utility there that does it all for you.