For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
select count(OBJID) as counter from oaminspectorshipments a inner join INSPECTOR_SHIPMENTS_PROPOSALS b on a.OBJID = b.PRESENTATION_ID inner join oamInspectorPOs c on b.PROPOSAL_ID = c.agreement_id where a.ridkey = 'psi08' and lower(c.PURCHASEORDER) = lower('tony-filter03');
SET LINESIZE 130 EXPLAIN PLAN FOR <your statement>; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY);
@?/rdbms/admin/utlxpls
SET AUTOTRACE ON EXPLAIN <run your statement>;