Hi,
I need a solution on materialized view refresh. The refresh method we are using here is "REFRESH FORCE".
when user A (Session A)is accessing materialized view MV1. Oracle job from the session (Session B) issues a materialized view refresh. This refresh removes data from MV1 and...
Hi,
I want to delete a multiple records from stored procedure in a single execution using INPUT parameter.
For example, i want to delete multiple records from EMP tables. The input parameter for this is Empnos(7348,7399,7468). Here i want to delete Employee numbers 7348,7399,7468 in a single...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.