Answer Posted / malkeet kaur
1)functions may or may not have return type but procedure doesn't have return type
2)functions are called from select statement but procedure can not called from select statement
3)fuctions are used when some data is passed to calling environment but procedure is used
when some processing to be done
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sqlca in powerbuilder?
What does stand for in sql?
Why do we use sqlite?
What is difference between sql and oracle?
What are different types of triggers?
What does truncate mean in sql?
What is the difference between database trigger and stored procedure?
what is a constraint? : Sql dba
Is drop table faster than truncate?
What is the primary key?
Differentiate between syntax and runtime errors.
What are the different tcl commands in sql?
what is index? : Sql dba
What is consistency?
What is function and procedure in pl sql?