function can return value ,procedure also return value through
out parameter then what is the difference?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / damodharan
function should always return only one value
but procedure may return a value value it may one or more
than one value
Is This Answer Correct ? | 1 Yes | 0 No |
What is row_number () in sql?
Explain the advantages and disadvantages of stored procedure?
Why we use sql profiler?
what is a trigger? : Sql dba
What are system versioned tables?
How can you know that statistics should be updated?
Whis is not false in primary key?
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?
How to run pl sql program in mysql?
What is user defined functions?
What is Data Concarency and Consistency?
how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.