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
What normalization means?
Explain the advantages and disadvantages of stored procedure?
Does execute immediate commit?
Why we use sql profiler?
What are the sql commands?
What is blind sql injection?
how many groups of data types? : Sql dba
Is left join same as join?
What is the difference between the sql*loader and import utilities? : aql loader
What is rank function in sql?
What is join view in sql?
How global cursor can be declare with dynamic trigger ?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Does sql*plus also have a pl/sql engine?
what are the differences between require and include, include_once and require_once? : Sql dba