Differentiate between function and procedure in Oracle.

  • Posted by Sharad Jaiswal

    A function is used to return a single value whereas a procedure doesn’t return any value. It returns multiple variables. This is achieved by passing variables by reference through OUT parameter.

Please Login or Register to leave a response.

Related Questions

Oracle Interview Questions

What is Oracle?

Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..

Oracle Interview Questions

Define Oracle database

An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...

Oracle Interview Questions

Explain Oracle instance.

Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database,..