Interested to Buy Any Domain ? << Click Here >> for more details...
function can return value ,procedure also return value through
out parameter then what is the difference?
- 3 Answers
- 8016 Views
- 3i Infotech, I also Faced
- E-Mail Answers
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 are the types of records?
What is an exception in PL/SQL? What are the two types of exceptions?
What sql does db2 use?
how to use 'mysql' to run sql statements? : Sql dba
What is dense_rank?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
What are the dml statements?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
what is foreign key? : Sql dba
How to get each name only once from an employee table?
define data blocks ? : Sql dba
What is set transaction?
How to rename a table?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
what are the performance and scalability characteristics of mysql? : Sql dba
