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
What is pessimistic concurrency control? : Transact sql
What is pl sql quora?
How to run sql*plus commands in sql developer?
Why do we use set serveroutput on?
Define the select into statement.
What is sql deadlock?
How do I run a query in pl sql developer?
explain mysql aggregate functions. : Sql dba
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is the execution plan in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What are few of the schema objects that are created using PL/SQL?
What is difference between stored procedures and application procedures?
How to display Row Number with Records in Oracle SQL Plus?
What are the most important characteristics of pl/sql?