Function accepts only in parameter but procedure accepts in,out and inout

What is difference between a PROCEDURE & FUNCTION ?

Question Posted / chandrasekar.ramasamy

6 Answers
12092 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / chandrasekar.ramasamy

Function accepts only in parameter but procedure accepts
in,out and inout
Function mostly used for mathamatical calculations
But procedure used to execute business logics

Is This Answer Correct ?

0 Yes

11 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the benefits of pl sql?

1121

What is a left join?

954

What is the use of index in sql?

1017

What are tables in sql?

1065

What are the two types of periodical indexes?

940

What is trigger in sql and its types?

1057

Is truncate ddl or dml?

991

What is a temporal data type?

1052

What is the difference between clustered and non-clustered indexes?

1093

Are stored procedures compiled?

926

Are subqueries better than joins?

976

What is sql exception?

974

explain access control lists. : Sql dba

1001

Is join an inner join?

976

Why use stored procedures?

1093