What is Difference between StoredProcedure and function?
Answer Posted / shankar
FUNCTION always return a value where as PROCEDURE may or
may not return value.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is difference between table and view?
What is the use of partition by in sql?
Which is the correct statement about truncate and delete?
What is bind variable in pl sql?
Explain commit, rollback and savepoint.
Can we alter stored procedure?
How do you write a complex sql query?
What is a common use of group by in sql?
What is difference between group by and partition by?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are three advantages to using sql?
how can we know the number of days between two given dates using mysql? : Sql dba
what is user defined functions? : Sql dba
How do I make my sql query run faster?
What is the most restrictive isolation level? : Transact sql