List the differences between plsql - function & procedures

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Does pl sql work in mysql?

687


Are left and right joins the same?

716


What is the difference between distinct and unique in sql?

650


Can I create table without primary key?

733


Is join same as left join?

752






What is primary key and foreign key?

715


How do I pipe the output of one isql to another?

722


What is sql key?

687


Is sql a microsoft product?

692


Explain the significance of the & and && operators in pl sql.

746


How do you identify a primary key?

811


What is structural independence and why is it important?

752


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

863


What is left inner join in sql?

722


what does the t-sql command ident_incr does? : Transact sql

805