-
编辑 删除
Oracle中统计表中每行字段符合条件的数量
--创建测试表CREATE TABLE TEST(a VARCHAR2(8),b NUMBER);INSERT INTO TESTSELECT 'name1',1 FROM dualUNIONSELECT 'name1',0 FROM dualUNIONSELECT 'name2',1 FROM dualUNIONSELECT 'name3',1 FROM dualUNIONSELECT 'name4',0 FROM dualUNIONSELECT 'name4',1 FROM dual;--查询出表中字段A中为1的多少个，为0的多少个SELECT a,count(*) as 总行数,sum(case when b=1 then 1 else 0 end) as 类型为1的数量,sum(case when b=0 then 1 else 0 end) as 类型为0的数量 from TESTGROUP by a ORDER BY a;[@more@]
-
编辑 删除
自动sqlldr脚本
auto_sqlldr.shoracleFilePath="/oradata/dypt/arch1/userModelFile/"oracleHome="/app/oracle/product/10204/db_1/bin/sqlldr"userID=user/pwd@ip:port:sidexport ORACLE_SID=YDPT1export ORACLE_HOME=/app/oracle/product/10204/db_1export PATH=.:$ORACLE_HOME/bin:$PATH:.date=`date '+%Y%m%d'`echo $datecd $oracleFilePathtxtFileName=`find . -name "$date*".txt`ctlFileName=`find . -name "$date*".ctl`logFileName=`find . -name "$date*".log`if [ "$logFileName"
