alexcol, did you resolve this task?
What is your oracle version ?
Desirably , biggest results from queries to attach as files.
Try to get plan of your of the problematic...
This phrase not means ,that not needed to growing as specialist.
This queries you can to send your DBA or perform yourself.
For a start - check execution plan your DELETE -statemet.
You are needed requesting the ASH -report by problem sql_id.
After, you can...
This code, provides from you ,is working and at sql engine and pls/sql engine.
t DATE := TRUNC ( ( ADD_MONTHS(SYSDATE- 1 , 7) ),...
Can you clarify why you planning to use the hint PUSH_SUBQ?
The use of the clause WITH provide to possibility to factorization of...
Prkhar,you are not right ,what ojgonzalezna not might to use this the syntax construct insert : insert into... values(select join)....
You re-create package from of dynamic -sql and later to calling it in application ?
It's problem can will be solved a few paths ::
For a start ...
0) pls, provide here ddl-describes your tables from query
1) may be to optimize of the logic your query
2) disable of...
For a start :
SELECT * FROM user_errors;
Your package uses dblink ?
if there is a suspicion that some session changes the package , then you...
Why here in your query use UNION , but no UNION ALL?
Of corse, your query will be terminate with error TO_MAY_ROWS .
You say that there is a student?
The acquired experience is your future.
Therefore, for a start try to write a request.
What is the key for...
Perhaps the source of duplicates is the view of "GLL".
What is key(logical PK-key or business-key) for the view GLL ?
It is also necessary to...
In your scheme, the co-worker has only linear dependence (submission)?
For example, Manager2 is also an employee and can be subordinate to...