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

How can I delete duplicate rows?

783


What is difference between db2 and sql?

755


how many tables will create when we create table, what are they? : Sql dba

817


What is sharding in sql?

764


What are the types of operators available in sql?

808


what is subquery? : Sql dba

814


How do I install microsoft sql?

760


what is 'mysqlshow'? : Sql dba

791


What does closing a cursor do?

1021


What are different sql data types?

720


How can you load microsoft excel data into oracle? : aql loader

876


What are sql data types?

783


What is sql trigger example?

798


What normalization means?

749


What are two statement types in sql?

790