what is difference between procedure and function

Answer Posted / k.sharada

procedure returns a value and function do not.

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can one get sql*loader to commit only at the end of the load file? : aql loader

791


What is rowid in sql?

695


What pl/sql package consists of?

855


What is difference between sql function and stored procedure?

716


What is the purpose of cursors in pl/sql?

832


what is self join and what is the requirement of self join? : Sql dba

889


Which is faster subquery or join?

888


hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1788


Explain the purpose of %type and %rowtype data types with the example?

767


What is a behavioral trigger?

729


How does stored procedure reduce network traffic?

767


how to present a past time in hours, minutes and seconds? : Sql dba

773


Describe types of sql statements?

763


What does over partition by mean in sql?

730


What are the sql commands?

839