1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Explain the difference between a FUNCTION, PROCEDURE and
PACKAGE.

Question Posted / guest


Explain the difference between a FUNCTION, PROCEDURE and PACKAGE...

Answer / Atendra Singh

FUNCTION and PROCEDURE are both database objects used for executing sets of SQL statements. However, they differ in a few key aspects:nn- A FUNCTION always returns a value, whereas a PROCEDURE does not return any value.n- Functions can be used as an expression within an SQL statement, while procedures cannot.nPACKAGE is a library containing one or more related functions and procedures. It allows for the grouping of multiple database objects into a single unit, improving organization and reusability.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1 Answers  

how to restore files with rman?

1 Answers  

What is dbcc? : sql server DBA

1 Answers  

What the different components in replication and what is their use? : sql server DBA

1 Answers  

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

1 Answers   EDS,

what is difference between user managed backup and rman backup?

1 Answers   CTS,

If CPU is very slow What can u do to speed up?

1 Answers  

How would you force a log switch?

4 Answers  

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

Explain the use of table functions.

1 Answers  

What is blocking and how would you troubleshoot it?

1 Answers  

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

For more DB Administration Interview Questions Click Here
Categories