what diffrence between function and procedure?

Answer Posted / deepu

functions and procedures are both pl/sql programs.
procedures performs a specific task,it takes parameters and
performs the actions.
functions are same as procedures except they wil return a
value.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3912


what are steps for interface? where is exchange rate defined in which table?

1720


Explain the use of rows option in exp command.

798


What is procedure overloading in oracle?

769


Explain the use of record option in exp command.

735


What is a subquery?

818


How to view existing locks on the database?

764


How to create a new tablespace in oracle?

731


Explain mutating triggers.

774


How to download oracle database 10g xe?

772


How to write numeric literals in oracle?

880


What is the usage of save points in oracle database?

722


What is integrity and what is constraint??Explain with example

1954


How to use "in out" parameter properly?

783


Give the different types of rollback segments.

779