Interested to Buy Any Domain ? << Click Here >> for more details...
List the differences between plsql - function & procedures
- 2 Answers
- 7293 Views
- TCS, Verizon, I also Faced
- E-Mail Answers
Answer Posted / lavanya
functions:
1.The parameters are input values and output values
2.The functions will return a value
3.The functions will be called with in sql
Procedures:
1.The parameters are input values and output values
2.The procedures will not return any value
3.The procedures will not be called with in sql
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Why do we create stored procedures & functions in pl/sql and how are they different?
Can procedure in package be overloaded?
How does index help in query performance?
how can we know the count/number of elements of an array? : Sql dba
What are the set operators in sql?
What is an exception in PL/SQL? What are the two types of exceptions?
Explain dml and ddl?
What is the difference between delete and truncate statement in sql?
Is ms sql traffic encrypted?
Why do we use procedures in pl sql?
Is primary key clustered or nonclustered?
What is sql*loader and what is it used for? : aql loader
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is the syntax to add a record to a table?
What port does sql server use?
