dbms_output.put_line & utl_file.put

Home

Help

	Welcome, Guest. Please login or register. Did you miss your activation email?	September 06, 2010, 02:13:26 am
		Login with username, password and session length

Data Warehousing Community Forum > Databases > Oracle > Topic: 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 629 times)

unknown

DW Apprentice

Reputation: +7/-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: +35/-0
Offline

Offline

Posts: 238

I 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.