ajay Kumar

• Nov 8th, 2005

 

DBMS_OUTPUT is a package & PUT_LINE  is a procedure . For print the value we write put_line

hi_ajay

 Profile Answers by hi_ajay Questions by hi_ajay

• Nov 8th, 2005

 

DBMS_OUTPUT is a PACKAGE and PUT_LINE is PROCEDURE . we  use  put_line for print .

vardhan_81

 Profile Answers by vardhan_81 Questions by vardhan_81

• Nov 9th, 2005

 

it is a package combination of two procedures.one is dbms_output and second one is put_line.this acts like print function.to display anything in plsql block we use DBMS_OUTPUT.PUT_LINE.

kiran babu

• Nov 10th, 2005

 

The transformation in which the out put row with the accurate result is happend on the derevations on the input colume .The execution process is depends on the expresions i.e. is applied on the input columes or the hot coted columes for the output .The output is then extracted and loaded using DBMS_OUTPUT.PUT_LINE. for any other transformations.

Anu

• Nov 10th, 2005

 

it is a print statement in pl/sql

Bansilal

• Jan 2nd, 2006

 

i think your answer is not correct please check once .if any reply me .

kehri_anurag

 Profile Answers by kehri_anurag Questions by kehri_anurag

• Jan 12th, 2006

 

DBMS_OUTPUT is a package that enable you to display the output from PL/SQL block or subprograms,and PUT_LINE is procedure which is define inside DBMS_OUTPUT package.

PUT_LINE procedure basically load the out put  to the SGA(System Global Area).so you have to setting SET SERVEROUTPUT ON  in SQL*PLUS to See the output.

knarender

 Profile Answers by knarender Questions by knarender

• Jul 2nd, 2007

 

DBMS_OUTPUT is one of the package ,in which PUT_LINE is used to print the line as output to the user.

sudhirnshinde

 Profile Answers by sudhirnshinde 

• Sep 30th, 2008

 

It is used to Display Message at SQL prompt in begin block statement.
We need to execute command SET SERVEROUTPUT ON at SQL prompt before using
DBMS_OUTPUT.PUT_LINE.

rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Oct 2nd, 2008

 

It's an PL/SQL Package which used to print messages .

dbxplorer

 Profile Answers by dbxplorer 

• May 30th, 2011

 

DBMS_OUTPUT is a Package and PUT_LINE is a Procedure.

PUT_LINE procedure places an entire line of into the buffer and that line is automatically followed  by the end-of-line marker i.e new line.

aravinthancse

 Profile Answers by aravinthancse Questions by aravinthancse

• Dec 27th, 2011

 

DBMS_OUTPUT - is a Oracle supplied package.
put_line() is a DBMS_OUTPUT packages inbuilt procedure.

put_line() is a combination of two inbuilt procedures such as put() and new_line().
procedure put() returns formatted string and new_line() returns the string in new line.

put_line() procedure load the result set into output buffer and then by using SET SERVEROUTPUT ON we can retrieved the output.

hardeep singh

• Oct 16th, 2015

 

The (dbms_output) is library and the (put_line) is the function declared inside library