a procedure can return none,one or more than one value but a function can

What is difference between Procedures and Functions ?

Question Posted / manojbatra071

Answer Posted / manojbatra071

a procedure can return none,one or more than one value but a
function can return one and only one value everytime

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1282

What is primary key and foreign key with example?

981

how does a local variable is defined using t-sql? : Transact sql

1059

Explain what is sql*plus?

1196

Does sql view stored data?

1003

What is cascade in sql?

1016

Where do we use pl sql?

1051

How can you load multi line records? : aql loader

1125

what happens if null values are involved in expressions? : Sql dba

1092

what is self join and what is the requirement of self join? : Sql dba

1188

How to look at the current sql*plus system settings?

1213

What are types of indexes in sql?

1128

What is scope and visibility in PL/SQL?

1289

how to calculate the difference between two dates? : Sql dba

1113

How do you get column names only for a table (sql server)?

1213