Database 101 FAQ

1. To get Oracle DB size in GB's:


select sum(bytes/1024/1024/1024) from dba_data_files;
2. Pagination in Oracle


select * from ( select rownum rnum, a.* from (YOUR_QUERY) a where rownum <= :M ) where rnum >= :N;
3. continued