I have a plsql blick which reads and insert rows into a table..I want to make sure that when this block runs no other query is running in the database..
The query should run between 10p and 6 am and when it fires automatically it should check if there any otjher queries running and run only when no query is running.
Is there a way to do this?
here is the query
insert into tab
select col1, col2 from
tab a, tabb, tab c
where <join conditions &filters>;