what is difference between procedure and function

Answer Posted / a.jyothsna

1) function can be executed using the sql command
(Ex: select functin_name(args)from dual;)
Procedure can be executed using sql+ command
(Ex: exec procedure_name(args))

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain raise_application_error.

851


What is dense_rank in sql?

720


Is primary key is clustered index?

740


What if we write return in procedure?

1007


How to use distinct and count in sql query? Explain

791


What is 19 null in sql?

719


Can we call a function containing dml statements in a select query?

748


What is mutating error?

717


Inline the values in PL/SQL, what does it mean.?

894


Which sql statement is used to delete data from a database?

677


What is a nested table in word?

725


Can we use view in stored procedure?

715


What is constant in pl sql?

732


Is clustered index a primary key?

710


How do I delete a trigger?

738