select instr(段落名,' ') from 表名 where 条件; 如果有空格则大于0,没有则为0 select * from (select t.*,rownum row_num from dplclaim t order by t.makedate desc) b where b.row_num between 1 and 75