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
How can I delete duplicate rows?
What is difference between db2 and sql?
how many tables will create when we create table, what are they? : Sql dba
What is sharding in sql?
What are the types of operators available in sql?
what is subquery? : Sql dba
How do I install microsoft sql?
what is 'mysqlshow'? : Sql dba
What does closing a cursor do?
What are different sql data types?
How can you load microsoft excel data into oracle? : aql loader
What are sql data types?
What is sql trigger example?
What normalization means?
What are two statement types in sql?