during runtime, when a cursor is opened.. when a new row is inserted into the base table, that satisfies the condition in select clause of declare cursor.. will that row be included in the result table after open cursor statement..
ie consider a table employee
declare c2 cursor for select employeeid, name from employee
at runtime, when a cursor is openend ,if a new row is added
will the new row be selected for the result table