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

what is a table in a database ? : Sql dba

1086

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

1002

Why do we need cursors in pl sql?

1147

How do you delete data from a table?

1092

how many values can the set function of mysql take? : Sql dba

1030

What is difference between sql and oracle?

1185

What is coalesce in sql?

1127

What is a null value?

1184

What is the difference between having clause and where clause?

1107

Is it important to partition hard disk?

1066

What is the difference between local and global temporary table?

1083

What are the various restrictions imposed on view in terms of dml?

1014

Are stored procedures faster than dynamic sql?

1099

What is string data type in sql?

1209

define sql insert statement ? : Sql dba

1076