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 the usage of nvl function?

0 Answers  


What is compute?

0 Answers  


How do I create a sql database?

0 Answers  


Can we use delete in merge statement?

0 Answers  


2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

1 Answers   Fintellix,






How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

0 Answers   MCN Solutions,


What does where 1/2 mean in sql?

0 Answers  


is mysql query is case sensitive? : Sql dba

0 Answers  


If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  


Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   Metric Stream, IBM,


how to shutdown mysql server? : Sql dba

0 Answers  


What is sql mysql pl sql oracle?

0 Answers  






Categories