What is the Difference between Procedure and Function.Can we
call a Function in a DML?

Answer Posted / sharad kumar

1. Function must return a value like any other Programing
Language.
2.yes we can call function from a DML.Remember count(*),sum
etc...

Is This Answer Correct ?    13 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the uses of sysdate and user keywords?

619


What pl/sql package consists of?

629


What do you mean by stored procedures?

541


How many aggregate functions are available there in sql?

522


What are all the ddl commands?

619






What is the difference between pl and sql?

536


How can I make sql query run faster?

552


What are local and global Indexes and where they are useful.

923


What is sql comments?

646


What is sql engine in oracle?

513


How do you delete a table?

529


Explain architecture of sql server notification services?

616


What is bind reference and how can it be created?

570


Why functions are used in sql?

509


What view means?

547