oracle最多能嵌套多少层,Oracle三层嵌套查询

Oracle三层嵌套查询以下文字资料是由(历史新知网www.lishixinzhi.com)小编为大家搜集整理后发布的内容，让我们赶快一起来看一下吧！

String sql= select oa_attinfo att_startstate oa_attinfo att_endstate +

oa_user user_realname oa_dept dept_name oa_attendtime att_starthour +

oa_attendtime att_startmin oa_attendtime att_endhour +

oa_attendtime att_endmin from oa_attinfo oa_user +

oa_dept oa_attendtime where to_char(oa_attinfo att_time YYYY MM DD )= +

year+ +strmonth+ +strdate+ and oa_attinfo att_user= +

user+ and oa_attinfo att_user=oa_user user_number and +

oa_user dept_number=oa_dept dept_number ;

其中的 oa_attinfo oa_user oa_dept为表名

select * from account where rowid in(select rid from (select rownum rn rid from(select rowid rid create_date from lishixinzhi/Article/program/Oracle/201311/18721

分页：123