diff b/w function and procedure?

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


Please Help Members By Posting Answers For Below Questions

what are numeric data types? : Sql dba

797


What are pl/sql cursors?

768


what tools available for managing mysql server? : Sql dba

787


How do I count duplicates in sql?

800


what is error ora-03113: end-of-file on communication channel?

861


What are the most important ddl statements in sql?

794


Can 2 queries be executed simultaneously in a distributed database system?

900


What do you know by pl/sql cursors?

806


What does trigger mean in slang?

785


What is a design view?

738


what is clause? : Sql dba

804


Which tcp/ip port does sql server run?

764


What is package in pl sql with an examples?

765


What is a heap in sql?

763


what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2237