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 dml and ddl?

740


describe mysql connection using mysql binary. : Sql dba

754


How to add new employee details in an employee_details table with the following details

823


What is the usage of distinct keyword?

816


Can you selectively load only those records that you need? : aql loader

773






How do you modify a table in sql?

802


Which data type is a composite type?

736


What are the possible values that can be stored in a boolean data field?

719


Can instead of triggers be used to fire once for each statement on a view?

712


What are the different tcl commands in sql?

815


How do you optimize a stored procedure in sql?

681


what are all the common sql function? : Sql dba

779


What is the difference between rollback and rollback to statements?

808


What is latest version of sql?

713


How to download oracle sql developer?

849