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

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

Question Posted / veena

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

Why query optimization is needed?

918

Can we rename a column in the output of sql query?

988

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

What are the types of triggers in sql?

1082

What is the process of copying data from table a to table b?

1085

What is a trigger in sql?

1198

Does access use sql?

1027

What are the operators used in select statements?

1051

What are predefined functions in sql?

1038

How do you update a sql procedure?

1019

Is sql the best database?

964

What is the difference between explicit and implicit cursors in oracle?

1056

how to add a new column to an existing table in mysql? : Sql dba

1062

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1052

How do you optimize a stored procedure in sql?

941