Oracle递归查询及查询含中文字段

 

1.递归查询

start with  ....... connect by prior  递归查询 ， 如果不加prior 则不进行深入递归查查询

 select *  from department d
  start with d.dep_parent_id in (select t.dep_id from test_depview t)
 connect by prior  d.dep_id = d.dep_parent_id;

 

 2.查询不包含中文数据

select t.dep_id
from department t
where t.level = '20'
and not regexp_like(t.dep_name, '[^\u4e00-\u9fa5]');

 

not regexp_like 为不匹配