function can return value ,procedure also return value through
out parameter then what is the difference?

Answers were Sorted based on User's Feedback



function can return value ,procedure also return value through out parameter then what is the diff..

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

function can return value ,procedure also return value through out parameter then what is the diff..

Answer / veena

We can use function in select statement but we can't use
procedure in select statement.

Is This Answer Correct ?    1 Yes 0 No

function can return value ,procedure also return value through out parameter then what is the diff..

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

Post New Answer

More SQL PLSQL Interview Questions

What is scalar function?

0 Answers  


What is the difference between a primary key and a unique key?

0 Answers  


What is java sql package?

0 Answers  


what is d diff between grant,commit,rollback n savepoint

1 Answers  


what is text? : Sql dba

0 Answers  


what is the difference between rownum pseudo column and row_number() function? : Sql dba

0 Answers  


Does access use sql?

0 Answers  


When to use inner join and left join?

0 Answers  


what are the 'mysql' command line options? : Sql dba

0 Answers  


Wat is SGA ?

3 Answers   ABB,


why sql is used as interpreter frequently rather than a compile?

1 Answers  


What is dynamic query?

0 Answers  


Categories