1) Create to directories on your hard drive. Place a small text file (ending in .txt) in one directory. Use Oracle package UTL_FILE to read that file, line by line, from one directory and prepare a similarly named file into the second directory. Before writing the file to the second directory check whether a file with the intended name already exists in that directory. If it does, do not overprepare it but rather rename that existing file (make a backup copy).
PLACE YOUR CODE and ITS OUTPUTS HERE. Please remove line numbers from your captured code.
2) Create an indefinitely running process that would insert a single row with a numeric primary key in one column and some kind of time stamp in the other column. Between two insertions, what 10 seconds. Control the wait between two insertions using Oracle packaged procedure:
You do want to have a way of telling that process to stop. Use tools provided by Oracle’s dbms_pipe package. Let that process periodically read a named pipe. If there appears a message “STOP” in that pipe, the process should stop.