what is difference between procedure and function

Answer Posted / a.jyothsna

1) function can be executed using the sql command
(Ex: select functin_name(args)from dual;)
Procedure can be executed using sql+ command
(Ex: exec procedure_name(args))

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we rollback delete command?

508


How do you take the union of two tables in sql?

511


List the ways to get the count of records in a table?

503


Where is all the data on the internet stored?

547


What is forward declaration in pl sql?

584






What is field delimiter?

627


What is blind sql injection?

566


Is there a 64 bit version of ssms?

509


What is a table in a database?

570


What is pivot table in sql?

518


What is the max nvarchar size?

512


What is a recursive join sql?

588


Is join an inner join?

531


What is indexes?

536


Can we connect to postgresql using sql developer?

484