Multiple choice technology databases

Which of the following procedure inserts terminating character when writing to a text file?

  1. NEW_LINE

  2. PUT

  3. PUT_LINE

  4. PUTF

  5. None of the above

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

PUT_LINE in UTL_FILE package writes text to a file and automatically appends a line terminator (newline character) after each call. PUT writes without any terminator, while PUTF is for formatted output without automatic line termination. NEW_LINE is not a valid UTL_FILE procedure.