Data Warehousing Community Forum

Databases => Oracle => Topic started by: unknown on January 19, 2008, 11:37:19 pm



Title: dbms_output.put_line & utl_file.put_line
Post by: unknown 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 ?


Title: Re: dbms_output.put_line & utl_file.put_line
Post by: Sipra 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.


Title: Re: dbms_output.put_line & utl_file.put_line
Post by: melina386 on February 10, 2010, 05:27:20 pm
Thanx for sharing

Data Entry India (http://www.e-datapro.net)