ajay Kumar
Answered On : Nov 8th, 2005
DBMS_OUTPUT is a package & PUT_LINE is a procedure . For print the value we write put_line
1 User has rated as useful.
Login to rate this answer.
DBMS_OUTPUT is a PACKAGE and PUT_LINE is PROCEDURE . we use put_line for print .
Login to rate this answer.
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.
Login to rate this answer.
kiran babu
Answered On : 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.
Login to rate this answer.
Anu
Answered On : Nov 10th, 2005
it is a print statement in pl/sql
Login to rate this answer.
Bansilal
Answered On : Jan 2nd, 2006
i think your answer is not correct please check once .if any reply me .
Login to rate this answer.
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.
2 Users have rated as useful.
Login to rate this answer.
DBMS_OUTPUT is one of the package ,in which PUT_LINE is used to print the line as output to the user.
Login to rate this answer.
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.
Login to rate this answer.
It's an PL/SQL Package which used to print messages .
Login to rate this answer.
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.
Login to rate this answer.
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.
1 User has rated as useful.
Login to rate this answer.
