Data Warehousing Community Forum Data Warehousing Community Forum
The Warehouse of Data warehousing knowledge ...
 
*
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


Pages: [1]   Go Down
  Print  
Author Topic: dbms_output.put_line & utl_file.put_line  (Read 629 times)
unknown
DW Apprentice
**

Reputation: +7/-0
Offline Offline

Posts: 44



View Profile
« 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 Smiley
Sipra
Founder
*****

Reputation: +35/-0
Offline Offline

Posts: 238


I am the King...


View Profile WWW
« 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.
Logged

melina386
DW Fresher
*

Reputation: +1/-3
Offline Offline

Posts: 7


View Profile WWW
« Reply #2 on: February 10, 2010, 05:27:20 pm »

Thanx for sharing

Data Entry India
Logged

Pages: [1]   Go Up
  Print  
 
Jump to:  



© Copyright 2006-2010 DW Forum. All rights reserved

contactSanghala | Cyber Militia | Powered by SMF | SMF © 2006-2009, Simple Machines LLC | Dilber MC Theme by HarzeM