when we use function instead of procedure? plz tell me the situation with ex?

when we use function instead of procedure? plz tell me the
situation with ex?

Question Posted / senthilsjc

3 Answers
9802 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

when we use function instead of procedure? plz tell me the situation with ex?..

Usually procedures are used when some action is to be
performed without retrun value.
Functions are used when some value is to be returned to the
calling enviornment.
You can not use procedure in the select statement however
functions can be used.

Is This Answer Correct ?

30 Yes

0 No

when we use function instead of procedure? plz tell me the situation with ex?..

Answer / priya

can we use default value in unique key?

Is This Answer Correct ?

4 Yes

2 No

when we use function instead of procedure? plz tell me the situation with ex?..

Answer / adil khan

procedure can only use in plsql not in sql. in other words
you can not use procedure in your select satatement. only
funtion can be used for example max(),min(),Avg() these all
are funtion not procedure.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer