What is Difference between StoredProcedure and function?
Answer Posted / prabhu karanam
We can use a function in the select query, but Procedure we
can't use in select query. But the function created with out
parameter, we can't use in select statement. Only in
parameter, we can use.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain some predefined exceptions.
What are the different operators available in sql?
What is graph sql?
what are the features and advantages of object-oriented programming? : Sql dba
What is the use of procedures?
Which kind of parameters cannot have a default value in pl sql?
Write a sql query to convert all character to uppercase after hypen.
When are we going to use truncate and delete?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What are the most important ddl statements in sql?
How do you respond to dementia behavior?
what is a relationship and what are they? : Sql dba
What are the different types of sql commands?
What is cross join sql?
what are different types of keys in sql?