p178.sql

来自「oracal的入门知识」· SQL 代码 · 共 6 行

SELECT *
  FROM (SELECT   addr, ts#, file#, dbarfil, dbablk, tch
            FROM x$bh
        ORDER BY tch DESC)
 WHERE ROWNUM < 11;