SQl判断空格 VS Oracle分页

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