Can a parameter be passed to a cursor?

devquora
devquora

Posted On: Feb 22, 2018

 

Yes, Parameters can be passed to explicit cursors. A cursor parameter could appear wherever a constant appears in a query.

Example:

CURSOR c1 (median IN NUMBER) IS
SELECT job, ename FROM emp WHERE sal > median;

    Related Questions

    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,..