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 Difference Between Unique and Primary Key Constraints?

594


What is sql deadlock?

556


Can you have a foreign key without a primary key?

505


What are the advantages of normalization?

542


What is type and rowtype in pl sql?

524






How do I edit a stored procedure?

540


How many tables can a sql database have?

519


What is the left table in sql?

509


Is sql dba a good career? : SQL DBA

521


How to start oracle sql developer?

550


- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?

1374


what is rdbms? : Sql dba

570


Why do we need sharding?

512


What are sql procedures?

571


What does the hierarchical profiler does?

557