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 Difference Between Unique and Primary Key Constraints?
What is sql deadlock?
Can you have a foreign key without a primary key?
What are the advantages of normalization?
What is type and rowtype in pl sql?
How do I edit a stored procedure?
How many tables can a sql database have?
What is the left table in sql?
Is sql dba a good career? : SQL DBA
How to start oracle sql developer?
- 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?
what is rdbms? : Sql dba
Why do we need sharding?
What are sql procedures?
What does the hierarchical profiler does?