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 are the advantages a stored procedure? : Sql dba

553


Why do we use subquery?

491


Why partition by is used in sql?

559


Can we use joins in subquery?

539


what is offset-fetch filter in tsql? : Transact sql

539






what are the advantages and disadvantages of cascading style sheets? : Sql dba

556


discuss about myisam index statistics collection. : Sql dba

531


What do you understand by pl/sql cursors?

554


How do I delete a trigger?

547


Is natural join same as inner join?

509


What is structural independence and why is it important?

551


How to place comments in pl/sql?

612


what is query cache in mysql? : Sql dba

581


Is trigger a stored procedure?

510


What are the types of index in sql?

539