select *
from t006
where cp001 = '03'
and cp002 || cp003 || to_char(ip001) in
(select cp002 || cp003 || to_char(ip001)
from t002
where cp001 = '03'
and cn029 = '财务部'
and lower(cp006) = 'y');
from t006
where cp001 = '03'
and cp002 || cp003 || to_char(ip001) in
(select cp002 || cp003 || to_char(ip001)
from t002
where cp001 = '03'
and cn029 = '财务部'
and lower(cp006) = 'y');
解决方案 »
- 高分解决Oracle中sql语句问题
- 有没人知道在oracle数据库中,包含列的内容,注释,数据类型;以及表的信息的数据字典
- ref cursor 问题请教
- ############高分----sql语句------################
- 请问在记录数为5万条时,select * from table order by id desc,是查询耗时还是排序耗时?
- 求ORACLE 9.0.1的补丁
- group by 问题
- 关于net8 configuration Assistant的问题
- 十里开源最新决策『十里开源__http://www.opensource.com.cn』
- 为什么我的98机子,装oracle 客户端,sql plus 连接不通??????? 急!!(我的 net8 configurration assistant 测试是成功的)
- oracle中的游标和dataset类似吗?
- 散分请教数据库如何恢复
from t002
where cp001 = '03'
and cn029 = '财务部'
and lower(cp006) = 'y');----这一步建临时表,然后建索引
/*+parallel(t 3)*/---是并行t为表t006的别名
select /*+parallel(t 3)*/ *
from t006 t
where cp001 = '03'
and cp002 || cp003 || to_char(ip001) in