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

Can sql function call stored procedure?

739


What is cursor status?

931


what is the difference between group by and order by in sql? : Sql dba

766


How do I run a script in sql developer?

703


How to install oracle sql developer?

772






what is meant by nl2br()? : Sql dba

764


Why trigger is used in sql?

691


What is schema in sql?

683


How many types of cursors are available in pl/sql?

773


Explain the update statement in sql

731


What is rownum in sql?

762


What is sql procedures and functions?

746


Explain locks? : Transact sql

740


Why is pl sql used?

688


what is the difference between primary key and unique key? : Sql dba

708