what is the differnce between procedure and function?
in both dml operations can work and in procedure through out
parameter you can return value ,then what is the differce?
- 3 Answers
- 7039 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / dinakar
Though Procedure returns a value through OUT parameter, it
cannot be used in SELECCT statement. Whereas a function can
be called in SELECT statement.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is sql keyword?
How do I find duplicates in the same column?
Can unique keys be null?
What pl/sql package consists of?
explain the difference between bool, tinyint and bit. : Sql dba
What is java sql driver?
how to rename an existing table in mysql? : Sql dba
Can you load data into multiple tables at once? : aql loader
Why having clause is used in sql?
Is it possible to create startup or shutdown trigger for on-schema?
Does view contain data?
Does truncate need commit?
how to check server status with 'mysqladmin'? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
What are the ddl commands?
