Do I need to add CHAR (13) to put_line () in Oracle to use fflush ()?

Question

I read that to use a function fflush()in oracle, each line in the output must end with a new line character. Will it put_line()automatically enter a new line character that needs work fflush()?

What is the new line symbol ( \r\nor \nor OS dependent) that is needed fflush()? And what is the new line ( \r\nor \nor OS dependent) that put_line()introduces, if at all?

Answer 1

Yes, put_line()adds the required newline character. From the documentation forput_line() :

, , , . . PUT_LINE , .

put() put_line():

PUT; NEW_LINE PUT_LINE .

, fflush() " ", put_line() " " ", - .

, , , utl_file ( PL/SQL) . , put_line() new_line(), \n \r\n; , , .