110,536
社区成员
发帖
与我相关
我的任务
分享
with aa as (select dvid from
(select dvid,level as llevel
from vw_x_dvlist
connect by dvpid=prior dvid
start with invname like '%汽%'
) a
group by dvid having sum(llevel)=1)
select b.*,level as llevel from dm_dvfile b
connect by b.dvpid=prior b.dvid
start with dvid in (
select dvid from aa
);
OracleConnection=New OracleConnection(_cn);
OracleCommand oracmd=new Oraclecommand();
oracmd.Connection=oracn;
OracleDataAdapter orada=new OracleDataAdapter(oracmd);
DataSet ds=new DataSet();
oracmd.Commandtext="上述SQL脚本"
orada.Fill(ds); --在此处长时间没有响应,报操作超时错误
oracmd.CommandType=CommandType.StoredProcedure;