can i use dbms_output.put_line in a function u are telling
as return statement
Answers were Sorted based on User's Feedback
Answer / hamdy
Yes we can use dbms_output.put_line in a function,
Function is a subprogram used for do some business process
or some calculations and return value.
DBMS_output.put_line used for Print something to the screen
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / babu
Functions are always called by a program and its duty is to
return a value to the calling program, on the other hand,
dbms_output is used to print something to the screen and it
would not be of any significance here.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / shail
The significance of using dbms_output can be while
debugging any plsql unit and nothing more.
Is This Answer Correct ? | 4 Yes | 0 No |
this statement is only used for print nothing more.
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / a.jyothsna
instead of return we can't use document_output......
But for general we can use
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / gourvendra singh
Yes we can use the dbms_output.put_line in a function and
it will print the msg when we execute Function_name, it
will not display any value if we use the function to return
a value, consider the following code:
create or replace function abc_test return char is
a varchar2(20);
begin
select dname into a from dept where deptno=20;
dbms_output.put_line('the dept is ');
return a;
exception
when others then
a:='no dept';
dbms_output.put_line('the dept is ');
return a;
end;
this will work.
Is This Answer Correct ? | 5 Yes | 4 No |
Answer / manoj
I agree with Babu with that there is no significance of
dbms_output...in the function..
Is This Answer Correct ? | 0 Yes | 0 No |
Explain ttitle and btitle.
What is a temporal data type?
Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?
If records are inserted into table without committing.How to refer to these values in a procedure?
Explain what is a view?
how to write date and time literals? : Sql dba
How to maintain the history of code changes of pl/sql?
Why do we need a foreign key?
what are the features and advantages of object-oriented programming? : Sql dba
What is the difference between rename and alias?
what is a table in a database ? : Sql dba
i have some prob lem to tell me about my self in interview first round ...