SQL Oracle: Tips&Tricks

How to know which version of DB is used? 

   select * from v$version

Pagination on Oracle by RowNum

link on oracle 

Examples: worked query

SELECT PGM_META_ID
            FROM 
              (select a.*, rownum rnum
                FROM
                  (select * from
                  PGM_EPISODEINFO
                  WHERE  EPISODE_TITLE is null) a
                WHERE rownum <= 150
              )
            WHERE rnum >= 148

... in progress (not work)...

select * FROM ID_MAP WHERE PGM_META_ID in         
  (SELECT PGM_META_ID
            FROM 
              (select a.*, rownum rnum
                FROM
                  (select * from
                  PGM_EPISODEINFO
                  WHERE  EPISODE_TITLE is null) a
                WHERE rownum <= 150
              )
            WHERE rnum >= 148);