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;
Never Miss an Articles from us.
Oracle is a database server that is used to handle data in a structured manner. It lets its users to retrieve and to st..
An Oracle database can be termed as a compilation of data housed in a database server and treated like a large unit...
Each operating Oracle database is associated with an Oracle instance. As soon as a database server starts the database,..