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


Please Help Members By Posting Answers For Below Questions

What is the use of function in sql?

730


Why left join is used in sql?

701


what is oracle database ? : Sql dba

736


what is data manipulation language? : Sql dba

702


Explain raise_application_error.

830






State few characteristics of pl/sql?

723


What is mutating trigger?

768


What will you get by the cursor attribute sql%notfound?

777


How to add a column ‘salary’ to a table employee_details?

770


Is left join faster than inner join?

840


What is execute immediate?

718


what is row? : Sql dba

933


How bulk collect improves performance?

742


Is json a nosql?

723


what is index? : Sql dba

747