function must return value whereas procedure may or maynot return value

diff b/w function and procedure?

Question Posted / rupesh

9 Answers
15607 Views
iFlex, I also Faced
E-Mail Answers

Answer Posted / rupesh

function must return value whereas procedure may or maynot
return value
Call to Function can be encounter by using select
statement where as procedure can not be call in select
statement

Is This Answer Correct ?

15 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are all the different types of indexes?

1145

Why commit is not used in triggers?

1033

Is there a 64 bit version of ssms?

954

define data blocks ? : Sql dba

974

What is cte sql?

979

Define union, minus, union all, intersect ?

996

What are the subsets of sql?

1119

What is record type in pl sql?

982

What is a sql select statement?

1031

What is pl/sql language case sensitive?

1107

Is it possible to link two groups inside a cross products after the cross products group has been created?

1000

How do you optimize a query?

990

How to set up sql*plus output format in oracle?

1027

What does the sign mean in sql?

982

What is cross join example?

986