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 the use of function in sql?
Why left join is used in sql?
what is oracle database ? : Sql dba
what is data manipulation language? : Sql dba
Explain raise_application_error.
State few characteristics of pl/sql?
What is mutating trigger?
What will you get by the cursor attribute sql%notfound?
How to add a column ‘salary’ to a table employee_details?
Is left join faster than inner join?
What is execute immediate?
what is row? : Sql dba
How bulk collect improves performance?
Is json a nosql?
what is index? : Sql dba