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 do you mean by stored procedures?
Can we have two clustered index on a table?
How delete a row in sql?
Is sql a backend?
what is column? : Sql dba
Can we create index on primary key?
How to Execute a Package in PL/SQL.?
What is sharding in sql?
What do you understand by pl/sql packages?
what is a table in a database ? : Sql dba
Why is nosql good?
How can we optimize a sql query?
Are there any features that are decommissioned in 11g that are not present in 11g?
How many types of indexes are there in sql?
How many types of relationship are there?