select count(*) into m_yl from lsb_wx where
sdsj between to_date(m_qssj,'yyyy-mm-dd')
and to_date(m_zzsj,'yyyy-mm-dd')+0.99999
and czjg in('S216','S226')
and gh=t.zjygh and gdbh like :var||'%';var = 'y','z','t'等
sdsj between to_date(m_qssj,'yyyy-mm-dd')
and to_date(m_zzsj,'yyyy-mm-dd')+0.99999
and czjg in('S216','S226')
and gh=t.zjygh and gdbh like :var||'%';var = 'y','z','t'等
解决方案 »
- 我想知道要读懂以下内容,应该学习ORACLE的那些相关内容呢?
- oracle怎么把update(含max函数的语句)改为merge into呢?
- 为何不能打开企业管理器
- MFC ADO SQL delete语句执行进度问题,求教!
- oracle怎样备份表而不备份表里的数据?
- 关于oracle里查询
- Oracle9i的服务器端和客户端可以装在同一台机子吗?
- 我在查询v$latch时oracle报ORA-03113: end-of-file on communication channel,请解答一下。
- 高手告诉我TRUNC (date)和ROUND (date)的用法和区别吧谢谢了
- 如何更改表空间,使表空间的区管理从“本地管理”变为“在字典中管理”
- sql*loadr and blob
- 执行动态sql,系统提示错误"ORA-00942:表或视图不存在 ",特别奇怪,请高手帮忙解决!
create or replace view v_test as
select substr(gdbh,1,1) GGG from lsb_wx where
sdsj between to_date(m_qssj,'yyyy-mm-dd')
and to_date(m_zzsj,'yyyy-mm-dd')+0.99999
and czjg in('S216','S226')
and gh=t.zjygh FOR C_I IN (select count(*) CN from v_test group by GGG) LOOP
DDD:=C_I.CN;
....END LOOP;
sdsj between to_date('20020206','yyyy-mm-dd')
and to_date('20020506','yyyy-mm-dd')+0.99999
and czjg in('S216','S226')
GROUP BY (substr(gdbh,1,1));
分给不给你们,看我的心情了。