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

What's the procedure?

875

What are functions in sql?

914

How can we store rows in PL/SQL using array?

1170

How bulk collect improves performance?

956

What is a constraint?

971

Can we call procedure in select statement?

986

Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

996

how do you know the version of your mysql server? : Sql dba

949

How do I run a sql query?

974

What is primary key in db?

945

Why are sql stored procedures used?

1003

How do rank () and dense_rank () differ?

985

How does postgresql compare to "nosql"?

991

What is the maximum number of columns in sql table?

1097

What is duration in sql profiler trace?

1030