Though a procedure returns a value through OUT parameter, it cannot be us

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

Question Posted / dinakar

3 Answers
8121 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

Please Help Members By Posting Answers For Below Questions

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1113

How to use distinct and count in sql query? Explain

1080

Explain the the update statement in sql?

1098

what is the use of friend function? : Sql dba

1057

What is a natural join sql?

1035

What is where clause in sql?

1086

Can sql developer connect to db2?

1102

what is 'mysqlshow'? : Sql dba

1073

Is join an inner join?

1021

How to write a query to show the details of a student from students table whose

1059

Is sql a dbms?

1059

What is the use of index in hive?

1052

What is the use of nvl function?

1239

Can we insert data into view?

948

What is the main reason behind using an index?

1057