select count(*) from winduser.TB_object_1090
select * from winduser.TB_object_1018
--公用信息(TB_1090)20110418
select a.f16_1090 zqdm,a.f5_1090 ssdd,substr(a.ob_object_name_1090,1,10) zqjc,
a.f4_1090 zqlb,a.f16_1090 jydm,a.rp_gen_datetime rp_gen_datetime ,b.ob_object_name_1018
from winduser.TB_object_1090 a ,winduser.TB_OBJECT_1018 b
where a.OB_REVISIONS_1090 = b.F34_1018
and a.f19_1090=0
--股票基本信息(TB_1432)只取最新股本信息20090826
select count(*) from winduser.tb_object_1432
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f1_1432 gsdm,a.f24_1432 ltgb,
a.f27_1432 zgb,a.f45_1432 zxbz,a.f46_1432 ggrq,a.rp_gen_datetime
from winduser.tb_object_1432 a,winduser.TB_object_1090 b
where a.f1_1432=b.OB_REVISIONS_1090 and a.f45_1432=1
and b.f19_1090=0
--基金基本信息(TB_1099)
select * from winduser.Tb_Object_1115 where F6_1115=1
--20090929 用"证券代码"字段关联wind数据库基金份额表(TB_OBJECT_1115)中相同字段，然后取F6_1115字段值为1的F5_1115字段内容即可。
--20101220 最后一列增加基金全称
--20110503 最后一列增加基金合计份额
select a.F1_1099,b.f16_1090 zqdm,b.f5_1090 ssdd, a.f14_1099 jjdm,b.ob_object_name_1090 jjmc,
a.f31_1099 ggrq,round(c.F5_1115,4) jjfxfe ,a.f100_1099 jjtzlx,a.f93_1099 jjtzfg,a.rp_gen_datetime,a.OB_OBJECT_NAME_1099,round(c.f14_1115,4)
from winduser.tb_object_1099 a ,winduser.TB_object_1090 b left outer join winduser.Tb_Object_1115 c
on b.F2_1090=c.f1_1115 and c.F6_1115=1
where a.F1_1099=b.F2_1090
and b.f19_1090=0
order by a.F1_1099
--普通债券基本信息
select * from winduser.TB_object_1270
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f32_1429 zqmc,a.f9_1429 fxze,
a.f7_1429 Ssrq,c.f8_1270 fxr,a.f19_1429 Zqmz,a.f26_1429 Fxjg,a.f20_1429 Qxrq,
a.f30_1429 Dqrq,a.f11_1429 Lllx,a.f38_1429 Fxpl,a.f64_1429 Mnfxcs,a.rp_gen_datetime
from winduser.tb_object_1429 a ,winduser.TB_object_1090 b left outer join winduser.TB_object_1270 c
on b.F2_1090=c.f1_1270
where a.f1_1429=b.F2_1090
and b.f19_1090=0
--普通债券基本信息去掉付息日20090826增加最后一列增加基金全称20101220
select b.f16_1090 zqdm,b.f5_1090 ssdd,b.ob_object_name_1090 zqmc,a.f9_1429 fxze,b.f4_1090 zqlb,
a.f7_1429 Ssrq,a.f19_1429 Zqmz,a.f26_1429 Fxjg,a.f20_1429 Qxrq,
a.f30_1429 Dqrq,a.f14_1429 pmll,a.f11_1429 Lllx,a.f38_1429 Fxpl,a.f64_1429 Mnfxcs,a.rp_gen_datetime,a.F32_1429
from winduser.tb_object_1429 a ,winduser.TB_object_1090 b
where a.f1_1429=b.F2_1090
and b.f19_1090=0
select * from winduser.tb_object_1269
select * from winduser.TB_object_1429
--可转债券基本信息
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f1_1269 gsdm,a.f5_1269 fxze,
a.f9_1269 Ssrq,c.f8_1270 fxr,a.f6_1269 Zqmz,a.f82_1269 Fxjg,a.f28_1269 Qxrq,a.f29_1269 Dqrq,
a.f56_1269 Lllx,a.f58_1269 Fxpl,a.f83_1269 Mnfxcs,a.f59_1269 Sfkfl,a.rp_gen_datetime
from winduser.tb_object_1269 a ,winduser.TB_object_1090 b left outer join winduser.TB_object_1270 c
on b.F2_1090=c.f1_1270
where a.f1_1269=b.OB_REVISIONS_1090
and b.f19_1090=0
--可转债券基本信息去掉付息日20090826
select b.f16_1090 zqdm,b.f5_1090 ssdd,b.ob_object_name_1090 zqmc,a.f5_1269 fxze,b.f4_1090 zqlb,
a.f9_1269 Ssrq,a.f6_1269 Zqmz,a.f82_1269 Fxjg,a.f28_1269 Qxrq,a.f29_1269 Dqrq,
a.F57_1269 ll,a.f56_1269 Lllx,a.f58_1269 Fxpl,a.f83_1269 Mnfxcs,a.f59_1269 Sfkfl,a.rp_gen_datetime
from winduser.tb_object_1269 a ,winduser.TB_object_1090 b
where a.f1_1269=b.OB_REVISIONS_1090
and b.f19_1090=0
--基金净值信息(TB_1101)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f14_1101 jjdm,b.ob_object_name_1090 jjmc,
a.f13_1101 jzrq,a.f4_1101 jjjz,a.f12_1101 ljjjjz,a.rp_gen_datetime
from winduser.tb_object_1101 a,winduser.TB_object_1090 b
where a.F14_1101=b.f2_1090
and a.f13_1101>=(select to_char(sysdate-20,'yyyymmdd') from dual)
and b.f19_1090=0
--债券净价信息(TB_1621)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 kpj,a.f4_1621 zgj,
a.f5_1621 zdj,a.f6_1621 spj,a.rp_gen_datetime
from winduser.tb_object_1621 a,winduser.TB_object_1090 b
where a.f1_1621=b.f2_1090
and b.f19_1090=0
--债券全价信息(TB_1448)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1448 rq,a.f3_1448 kpj,a.f4_1448 zgj,
a.f5_1448 zdj,a.f6_1448 spj,a.rp_gen_datetime
--select count (*) 差十几个
from winduser.tb_object_1448 a,winduser.TB_object_1090 b
where a.f1_1448=b.f2_1090
and b.f19_1090=0
select * from A004JJHZGZB where fdate=(select max(fdate) from A004JJHZGZB)
--债券价格信息(TB_1621,TB_1448)20090826
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 jjkpj,a.f4_1621 jjzgj,
a.f5_1621 jjzdj,a.f6_1621 jjspj,c.f3_1448 qjkpj,c.f4_1448 qjzgj,
c.f5_1448 qjzdj,c.f6_1448 qjspj,max(a.rp_gen_datetime) jjtime,max(c.rp_gen_datetime) qjtime
from winduser.tb_object_1621 a,winduser.TB_object_1090 b,winduser.tb_object_1448 c
where a.f1_1621=b.f2_1090 and c.f1_1448=b.f2_1090 and c.f2_1448=a.f2_1621
and a.f2_1621>=(select to_char(sysdate-20,'yyyymmdd') from dual)
and b.f19_1090=0
group by b.f16_1090,b.f5_1090,a.f2_1621,a.rp_gen_datetime,c.rp_gen_datetime,a.f3_1621,
a.f4_1621,a.f5_1621,a.f6_1621,c.f3_1448,c.f4_1448,c.f5_1448,c.f6_1448
order by b.f16_1090
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 kpj,a.f4_1621 zgj,
a.f5_1621 zdj,a.f6_1621 spj,max(a.rp_gen_datetime )
from winduser.tb_object_1621 a,winduser.TB_object_1090 b
where a.f1_1621=b.f2_1090 and b.f16_1090='009908'
group by b.f16_1090,b.f5_1090,a.f2_1621,a.rp_gen_datetime,a.f3_1621,a.f4_1621,
a.f5_1621,a.f6_1621
order by a.f2_1621
order by b.f16_1090
Select f1_1621,max(rp_gen_datetime)
From winduser.tb_object_1621
group by f1_1621,to_char(rp_gen_datetime,'yyyymmdd')
order by to_char(rp_gen_datetime,'yyyymmdd')
select * from winduser.tb_object_1621 where f1_1621='010004' order by rp_gen_datetime
--债券风险收益指标(TB_1639)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1639 rq,a.f4_1639 jq,
a.f5_1639 xzjq,a.rp_gen_datetime
--select count (*)
from winduser.tb_object_1639 a,winduser.TB_object_1090 b
where a.f1_1639=b.f2_1090
select count(*) from winduser.TB_object_1090
select * from winduser.TB_object_1018
--公用信息(TB_1090)20110418
select a.f16_1090 zqdm,a.f5_1090 ssdd,substr(a.ob_object_name_1090,1,10) zqjc,
a.f4_1090 zqlb,a.f16_1090 jydm,a.rp_gen_datetime rp_gen_datetime ,b.ob_object_name_1018
from winduser.TB_object_1090 a ,winduser.TB_OBJECT_1018 b
where a.OB_REVISIONS_1090 = b.F34_1018
and a.f19_1090=0
--股票基本信息(TB_1432)只取最新股本信息20090826
select count(*) from winduser.tb_object_1432
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f1_1432 gsdm,a.f24_1432 ltgb,
a.f27_1432 zgb,a.f45_1432 zxbz,a.f46_1432 ggrq,a.rp_gen_datetime
from winduser.tb_object_1432 a,winduser.TB_object_1090 b
where a.f1_1432=b.OB_REVISIONS_1090 and a.f45_1432=1
and b.f19_1090=0
--基金基本信息(TB_1099)
select * from winduser.Tb_Object_1115 where F6_1115=1
--20090929 用"证券代码"字段关联wind数据库基金份额表(TB_OBJECT_1115)中相同字段，然后取F6_1115字段值为1的F5_1115字段内容即可。
--20101220 最后一列增加基金全称
--20110503 最后一列增加基金合计份额
select a.F1_1099,b.f16_1090 zqdm,b.f5_1090 ssdd, a.f14_1099 jjdm,b.ob_object_name_1090 jjmc,
a.f31_1099 ggrq,round(c.F5_1115,4) jjfxfe ,a.f100_1099 jjtzlx,a.f93_1099 jjtzfg,a.rp_gen_datetime,a.OB_OBJECT_NAME_1099,round(c.f14_1115,4)
from winduser.tb_object_1099 a ,winduser.TB_object_1090 b left outer join winduser.Tb_Object_1115 c
on b.F2_1090=c.f1_1115 and c.F6_1115=1
where a.F1_1099=b.F2_1090
and b.f19_1090=0
order by a.F1_1099
--普通债券基本信息
select * from winduser.TB_object_1270
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f32_1429 zqmc,a.f9_1429 fxze,
a.f7_1429 Ssrq,c.f8_1270 fxr,a.f19_1429 Zqmz,a.f26_1429 Fxjg,a.f20_1429 Qxrq,
a.f30_1429 Dqrq,a.f11_1429 Lllx,a.f38_1429 Fxpl,a.f64_1429 Mnfxcs,a.rp_gen_datetime
from winduser.tb_object_1429 a ,winduser.TB_object_1090 b left outer join winduser.TB_object_1270 c
on b.F2_1090=c.f1_1270
where a.f1_1429=b.F2_1090
and b.f19_1090=0
--普通债券基本信息去掉付息日20090826增加最后一列增加基金全称20101220
select b.f16_1090 zqdm,b.f5_1090 ssdd,b.ob_object_name_1090 zqmc,a.f9_1429 fxze,b.f4_1090 zqlb,
a.f7_1429 Ssrq,a.f19_1429 Zqmz,a.f26_1429 Fxjg,a.f20_1429 Qxrq,
a.f30_1429 Dqrq,a.f14_1429 pmll,a.f11_1429 Lllx,a.f38_1429 Fxpl,a.f64_1429 Mnfxcs,a.rp_gen_datetime,a.F32_1429
from winduser.tb_object_1429 a ,winduser.TB_object_1090 b
where a.f1_1429=b.F2_1090
and b.f19_1090=0
select * from winduser.tb_object_1269
select * from winduser.TB_object_1429
--可转债券基本信息
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f1_1269 gsdm,a.f5_1269 fxze,
a.f9_1269 Ssrq,c.f8_1270 fxr,a.f6_1269 Zqmz,a.f82_1269 Fxjg,a.f28_1269 Qxrq,a.f29_1269 Dqrq,
a.f56_1269 Lllx,a.f58_1269 Fxpl,a.f83_1269 Mnfxcs,a.f59_1269 Sfkfl,a.rp_gen_datetime
from winduser.tb_object_1269 a ,winduser.TB_object_1090 b left outer join winduser.TB_object_1270 c
on b.F2_1090=c.f1_1270
where a.f1_1269=b.OB_REVISIONS_1090
and b.f19_1090=0
--可转债券基本信息去掉付息日20090826
select b.f16_1090 zqdm,b.f5_1090 ssdd,b.ob_object_name_1090 zqmc,a.f5_1269 fxze,b.f4_1090 zqlb,
a.f9_1269 Ssrq,a.f6_1269 Zqmz,a.f82_1269 Fxjg,a.f28_1269 Qxrq,a.f29_1269 Dqrq,
a.F57_1269 ll,a.f56_1269 Lllx,a.f58_1269 Fxpl,a.f83_1269 Mnfxcs,a.f59_1269 Sfkfl,a.rp_gen_datetime
from winduser.tb_object_1269 a ,winduser.TB_object_1090 b
where a.f1_1269=b.OB_REVISIONS_1090
and b.f19_1090=0
--基金净值信息(TB_1101)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f14_1101 jjdm,b.ob_object_name_1090 jjmc,
a.f13_1101 jzrq,a.f4_1101 jjjz,a.f12_1101 ljjjjz,a.rp_gen_datetime
from winduser.tb_object_1101 a,winduser.TB_object_1090 b
where a.F14_1101=b.f2_1090
and a.f13_1101>=(select to_char(sysdate-20,'yyyymmdd') from dual)
and b.f19_1090=0
--债券净价信息(TB_1621)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 kpj,a.f4_1621 zgj,
a.f5_1621 zdj,a.f6_1621 spj,a.rp_gen_datetime
from winduser.tb_object_1621 a,winduser.TB_object_1090 b
where a.f1_1621=b.f2_1090
and b.f19_1090=0
--债券全价信息(TB_1448)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1448 rq,a.f3_1448 kpj,a.f4_1448 zgj,
a.f5_1448 zdj,a.f6_1448 spj,a.rp_gen_datetime
--select count (*) 差十几个
from winduser.tb_object_1448 a,winduser.TB_object_1090 b
where a.f1_1448=b.f2_1090
and b.f19_1090=0
select * from A004JJHZGZB where fdate=(select max(fdate) from A004JJHZGZB)
--债券价格信息(TB_1621,TB_1448)20090826
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 jjkpj,a.f4_1621 jjzgj,
a.f5_1621 jjzdj,a.f6_1621 jjspj,c.f3_1448 qjkpj,c.f4_1448 qjzgj,
c.f5_1448 qjzdj,c.f6_1448 qjspj,max(a.rp_gen_datetime) jjtime,max(c.rp_gen_datetime) qjtime
from winduser.tb_object_1621 a,winduser.TB_object_1090 b,winduser.tb_object_1448 c
where a.f1_1621=b.f2_1090 and c.f1_1448=b.f2_1090 and c.f2_1448=a.f2_1621
and a.f2_1621>=(select to_char(sysdate-20,'yyyymmdd') from dual)
and b.f19_1090=0
group by b.f16_1090,b.f5_1090,a.f2_1621,a.rp_gen_datetime,c.rp_gen_datetime,a.f3_1621,
a.f4_1621,a.f5_1621,a.f6_1621,c.f3_1448,c.f4_1448,c.f5_1448,c.f6_1448
order by b.f16_1090
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1621 rq,a.f3_1621 kpj,a.f4_1621 zgj,
a.f5_1621 zdj,a.f6_1621 spj,max(a.rp_gen_datetime )
from winduser.tb_object_1621 a,winduser.TB_object_1090 b
where a.f1_1621=b.f2_1090 and b.f16_1090='009908'
group by b.f16_1090,b.f5_1090,a.f2_1621,a.rp_gen_datetime,a.f3_1621,a.f4_1621,
a.f5_1621,a.f6_1621
order by a.f2_1621
order by b.f16_1090
Select f1_1621,max(rp_gen_datetime)
From winduser.tb_object_1621
group by f1_1621,to_char(rp_gen_datetime,'yyyymmdd')
order by to_char(rp_gen_datetime,'yyyymmdd')
select * from winduser.tb_object_1621 where f1_1621='010004' order by rp_gen_datetime
--债券风险收益指标(TB_1639)
select b.f16_1090 zqdm,b.f5_1090 ssdd,a.f2_1639 rq,a.f4_1639 jq,
a.f5_1639 xzjq,a.rp_gen_datetime
--select count (*)
from winduser.tb_object_1639 a,winduser.TB_object_1090 b
where a.f1_1639=b.f2_1090
/1 
