function can return value ,procedure also return value through
out parameter then what is the difference?

Answer Posted / veena

We can use function in select statement but we can't use
procedure in select statement.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an invalid partition table?

750


How to run sql functions in pl/sql?

725


Is it possible to create the following trigger: before or after update trigger for each row?

926


How do I start pl sql?

671


how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

719






Does truncate need commit?

699


What sql database should I use?

788


what are the performance and scalability characteristics of mysql? : Sql dba

723


What is the usage of sql functions?

814


What is data control language?

736


What is view? Can we update view

1081


how would you get the current date in mysql? : Sql dba

724


What is a unique key?

776


What is the difference between a primary key and a clustered index?

697


Are there any features that are decommissioned in 11g that are not present in 11g?

1820