1 输出表的第一行记录
select * from table_name where rownum=1;
2 输出表的前两行记录select * from table_name where rownum<3;
3 输出表中从select * from(select rownum m,a.* from table_name a where rownum<21)where m>9;
4 查询表空间中数据文件具体位置select name from v$datafile;
5 查询表空间中具体文件的位置
select * FROM DBA_DATA_FILES;