function can return value ,procedure also return value through
out parameter then what is the difference?
Answer Posted / dinakar
Though a procedure returns a value through OUT parameter,
it cannot be used in a SELECT statement. Whereas a function
can be used in a SELECT statement.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
What is linq to sql?
What is query optimization in sql?
Is it possible to create startup or shutdown trigger for on-schema?
what is log shipping? : Sql dba
What is the main reason behind using an index?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Why use truncate instead of delete?
What is the syntax to add a record to a table?
what is 'mysqlcheck'? : Sql dba
Why do we use %rowtype & %type in plsql?
How do you update f as m and m as f from the below table testtable?
what is a join? : Sql dba
What is the difference between mdf and ndf files?
What are types of joins?
What is cold data?