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 are numeric data types? : Sql dba
What are pl/sql cursors?
what tools available for managing mysql server? : Sql dba
How do I count duplicates in sql?
what is error ora-03113: end-of-file on communication channel?
What are the most important ddl statements in sql?
Can 2 queries be executed simultaneously in a distributed database system?
What do you know by pl/sql cursors?
What does trigger mean in slang?
What is a design view?
what is clause? : Sql dba
Which tcp/ip port does sql server run?
What is package in pl sql with an examples?
What is a heap in sql?
what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?