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