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 a database transaction? : Sql dba
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
How do you go back in sql?
What is primary key and foreign key with example?
how to see the create table statement of an existing table? : Sql dba
What company owns postgresql?
how do you tune the slow running queries in oracle db , explain the methodology
How can I tell if sql is running?
How do I run a sql trace?
Can we create view in stored procedure?
what are tables and fields? : Sql dba
How do I remove sql plus from windows 10?
Why do we use cursors?
What is the maximum number of triggers, you can apply on a single table?
Why plvtab is considered as the easiest way to access the pl/sql table?