alter session set NLS_DATE_FORMAT = 'mm/dd hh24:mi'; set null '(null)' |
select tablespace_name , sum(bytes)/1024/1024 from dba_free_space group by tablespace_name; |
select * from ( select ROWNUM as id, empnum, ename, job from emp where job = 'MANAGER' order by empnum ) where id > 5 and id <= 10; |