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

Answer Posted / damodharan

function should always return only one value
but procedure may return a value value it may one or more
than one value

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is primary key an index?

713


What are sql triggers used for?

722


What is sqlite format?

812


What is secondary key?

670


How do you copy a table in sql?

751






How does a self join work?

689


what is the difference between char and varchar data types? : Sql dba

741


What is record in pl sql?

768


How does rowid help in running a query faster?

1155


how to create a test table in your mysql server? : Sql dba

684


Can you upgrade sql express to full sql?

709


What is a relationship and what are they?

780


Can pl sql procedure have a return statement?

722


What does the acronym acid stand for in database management?

775


How do I start sql from command line?

707