Proceure performs an action and function returns a value. Both have diffe

List the differences between plsql - function & procedures

Question Posted / iamanocp

Answer Posted / iamanocp

Proceure performs an action and function returns a value.
Both have different syntax for creation. Fucntion has
RETURN clause in its declaration.

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I save the results of sql query in a file?

974

What is the maximum number of columns in sql table?

1167

What is the starting oracle error number?

1051

What is the difference between left outer join and left join?

992

What are different types of sql commands?

1112

Can we rename a column in the output of sql query?

993

What does select top 1 do in sql?

1088

What is procedure and function?

976

When you have to use a default "rollback to" savepoint of plvlog?

1187

Is record in oracle pl sql?

958

What is a record in pl/sql?

1140

Is primary key always clustered index?

1019

What is the difference between null value, zero, and blank space?

1199

What is rowtype?

1015

Does truncate free space?

1005