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

What is sql deadlock?

575


What is difference sql and mysql?

541


What is nvarchar in sql?

535


What is sql architecture?

567


What is the difference between mdf and ndf files?

581






What is offset and limit in sql?

559


What is rename in sql?

562


How to get unique records from a table?

531


What is a full join?

536


What is a table?

573


Why do we create views in sql?

569


Can a foreign key be null?

599


how to enter numeric values as hex numbers? : Sql dba

580


Why is the cursor important?

550


What is program debugging?

582