What is the basic difference between EXPLAIN PLAN and AUTOTRACE in SQL Developer. Can anybody please elaborate?
This is the query on which I am trying to get the difference inbetween Autotrace and Explain Plan.
SELECT name, address, latest_in
FROM ( SELECT name, address, latest_in
ROW_NUMBER() OVER (PARTITION BY name ORDER BY address DESC) AS rowrank
FROM avrajit
)
WHERE rowrank <> 1 AND rowrank > 3;