I have a table that has a scan file name.
I have a fuction that takes the scan file name as a parameter and finds the file path.
I need to update a column in the table with this function output.
So, for every scan file name, I'll have an associated column value with the file path.
This sounds simple but I'm struggling. Can I update the column value with a function?
Any direction appreciated.
SQL> SET SERVEROUTPUT ON
SQL> EXEC DBMS_OUTPUT.PUT_LINE(FILE_LOC('file_name'));