can i use dbms_output.put_line in a function u are telling
as return statement

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is error ora-03113: end-of-file on communication channel?

607


What is a join query?

556


What version is sql?

554


Explain the difference between rename and alias?

544


What are the qualities of 2nf?

546






Is the primary key an index?

598


Does oracle roll back the transaction on an error?

539


How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

667


Can we use views in stored procedure?

515


Can we use the cursor's to create the collection in PL/SQL?

523


How many types of triggers exist in pl/sql?

572


What is pivot table in sql?

526


Which join is like an inner join?

527


What is rollback?

587


What is difference between cursor and trigger?

560