摘要：--首先自定义一种名为：row_month_report类型typecreate or replace type row_month_report as object(m_month varchar2(30),m_SluiceName varchar2(30),m_OneSluiceCount number,m_TwoSluiceCount number,m_OneUpEmptyCount number,m_OneDownemptyCount number,m_TwoUpemptyCount number,m_TwoDownemptyCount number,----------------- 阅读全文

摘要：1.首先要创建一个类型集合；create or replace type row_month_report as object---声明一种类型(m_month varchar2(30),m_SluiceName varchar2(30),m_OneSluiceCount number,m_TwoSluiceCount number,m_OneUpEmptyCount number,m_OneDownemptyCount number,m_TwoUpemptyCount number,m_TwoDownemptyCount number,------------------------这是写要 阅读全文

摘要：列子：Select name,num from test where rowid!=(select max(rowid) from test b where b.names=test.names andb.num=test.num);----------------------------------------- 速度优化，前一语句比后一语句的速度快几十倍select names,dates from test,bwhere test.names = b.names(+) and b.names is null and b.dates > date('2003-01-01 阅读全文