What is difference between Procedures and Functions ?

Answer Posted / devi

1.procedure does not return any value whree as functions
return values
2.a procedure can be called independently where as a
function is called inside a procedure

Is This Answer Correct ?    1 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does <> sql mean?

529


What are its different types of dbms?

531


How many sql databases can you have on one server?

586


What is oracle and pl sql?

657


How do I partition in sql?

533






What are the advantages of normalization?

550


What are database links used for?

590


what is oracle database ? : Sql dba

549


What are different types of tables in sql?

525


what is the difference between rownum pseudo column and row_number() function? : Sql dba

611


Can variables be used in sql statements?

548


How do you go back in sql?

526


Difference between truncate, delete and drop commands?

552


What is the most important ddl statements in sql are?

519


how to select first 5 records from a table? : Sql dba

506