Sign Up Login


  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 type and rowtype in pl sql?

0 Answers  

we have a package and we have grants to execute that package inside of that we have table, here we don't have privileges to this table? whether this package will execute or not?

3 Answers   TCS,

What is the use of sqlerrd 3?

0 Answers  

What is the purpose of a sql?

0 Answers  

What is database migration?

0 Answers  




Which command is used to call a stored procedure?

0 Answers  

What is a primary key, and how is it different from a unique key?

3 Answers  

What is Overloading of procedures ?

2 Answers  

Explain mutating table error.

0 Answers  

What is the use of & in pl sql?

0 Answers  

What is the difference between nested table and varray?

0 Answers  

How pl/sql source code can be protected?

3 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories