function can return value ,procedure also return value through
out parameter then what is the difference?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / damodharan
function should always return only one value
but procedure may return a value value it may one or more
than one value
Is This Answer Correct ? | 1 Yes | 0 No |
Can we have exception part in trigger ?
is mysql query is case sensitive? : Sql dba
Why is a primary key important?
what is the difference between char and varchar data types? : Sql dba
What is the best free sql database?
How can I get the number of records affected by a stored procedure?
What is a temporal table?
How many types of primary keys are there?
What sql does db2 use?
What is sql table?
which types of join is used in sql widely? : Sql dba
What is PL/SQL table ?