1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

List the differences between plsql - function & procedures

Question Posted / anusha.rpg

Answers were Sorted based on User's Feedback



List the differences between plsql - function & procedures..

Answer / 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

List the differences between plsql - function & procedures..

Answer / iamanocp

Proceure performs an action and function returns a value.
Both have different syntax for creation. Fucntion has
RETURN clause in its declaration.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

what is a database? : Sql dba

0 Answers  

Define tables and fields in a database

0 Answers  

What are the advantages of pl sql?

0 Answers  

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

What plvcmt and plvrb does in pl/sql?

0 Answers  




name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

how to escape special characters in sql statements? : Sql dba

0 Answers  

Can we join tables without foreign key?

0 Answers  

What is aggregate function in sql?

0 Answers  

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

Does execute immediate commit?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories