dbms_output.put_line & utl_file.put

Data Warehousing Community Forum > Databases > Oracle > dbms_output.put_line & utl_file.put_line

Pages: [1] Go Down

« previous next »

Author

Topic: dbms_output.put_line & utl_file.put_line (Read 1799 times)

unknown

DW Apprentice

Reputation: +8/-0
Offline

Offline

Posts: 44

dbms_output.put_line & utl_file.put_line

« on: January 19, 2008, 11:37:19 pm »

What is difference between dbms_output.put_line and utl_file.put_line ?

Any relation between the two ?


	Logged

Thanks
Unknown

Sipra

Founder

Reputation: +59/-0
Offline

Offline

Posts: 323

Am the King...

Re: dbms_output.put_line & utl_file.put_line

« Reply #1 on: March 21, 2008, 02:43:52 pm »

Hi,

The relation/difference between is dbms_output.put_line and utl_file.put_line –
dbms_output.put_line is used to display the output on the SQL prompt. utl_file.put_line is used to write to file.

Both functions are in different packages, STANDARD and UTL_FILE.
UTL_FILE does provide other functions for file operations and requires UTL_DIR to be setup properly.