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 |
HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.
Can a view be updated/inserted/deleted?If Yes under what conditions?
How do you explain an index?
What is denormalization in a database?
Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d
What is raid? How does it help storage of databases?
Which are sql * plus commands?
What do you mean by “trigger” in sql?
how to include comments in sql statements? : Sql dba
Does pdo prevent sql injection?
What can be a size of a pl/sql block? Is there any limit?
What is user in sql?