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?
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 scope and visibility in PL/SQL?
What is the difference between inner join and outer join?
Is the primary key an index?
What happens when a trigger is associated to a view?
How many sql commands are there?
What are the different set operators available in sql?
What are sql objects?
What are database links used for?
How do you drop a trigger?
what is log shipping? : Sql dba
How do I make my sql query run faster?
Is pl sql useful?
How many types of index are there?
What are the different type of joins in sql?
can sql servers linked to other servers like oracle? : Sql dba