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 row_number () in sql?

0 Answers  


Explain the advantages and disadvantages of stored procedure?

0 Answers  


Why we use sql profiler?

0 Answers  


what is a trigger? : Sql dba

0 Answers  


What are system versioned tables?

0 Answers  


How can you know that statistics should be updated?

0 Answers  


Whis is not false in primary key?

0 Answers   Fintellix,


Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ?

7 Answers   PreVator,


How to run pl sql program in mysql?

0 Answers  


What is user defined functions?

0 Answers  


What is Data Concarency and Consistency?

1 Answers  


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.

16 Answers  


Categories