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

how to shutdown mysql server? : Sql dba

573


How many types of tables are there?

509


Explain the purpose of %type and %rowtype data types with the example?

558


How to write a query to show the details of a student from students table whose

542


What is pl/sql language case sensitive?

635






What is update query?

551


What are hotfixes and patches?

532


what is the difference between truncate and drop statements? : Sql dba

558


what is a composite key ? : Sql dba

612


How do you know if a relationship is 2nf?

523


Does mysql support pl sql?

628


what is an index? : Sql dba

529


What are local and global variables and their differences?

592


How do you respond to dementia behavior?

533


Which is faster union or join?

497