Phoenix_99的专栏

1. select  cgicode ||orderclass ||fcode  from askquotelist where status>='70' and (asktype='01' or asktype='02')               and   ( ( rtexcetodate is null and rtexcedate      or  ( rtexcedategroup by cgicode ,orderclass ,fcode having count(*)>1select  c

mv.sh #! /bin/bash cd /home/tomcat/inimsbms/bmsfiles/ find -type f -mtime +1 -exec mv -f {} /home/tomcat/inimsbms/inimsfiles/ \; cd /home/tomcat/inimsbms/inimsfiles/ #rm -f [NO]DIPC_BMS_PARTS_[0-9]....

本体：   select t0.*, t1.RMBprice, t2.USDprice   from (select cgicode, orderclass           from askquotelist          where status >= '70'            and (asktype = '01' or asktype = '02')         ...

1、查出sid和serial# select object_name, machine, s.sid, s.serial# from v$locked_object l, dba_objects o, v$session s where l.object_id　 = 　o.object_id and l.session_id = s.sid; 2、杀掉进程 alter system

#! /bin/bash ftp -n open 10.192.19.179 user ncicbms ncicbms binary prompt mget pcc_bms_data01_2009*.* close bye !

update fobupricdetail  t1    set fobpriceusd2 = (select fobpriceusd2 from PUR_TEMP where cgicode = t1.cgicode and rownum = 1)    where exi

1、insert into auser (companycode,userid,usercode,username,userlevel,password,orgid,deleteflag,updatecount,createuser,createdate,updateuser,updatetime,expired) values('5BL9','5BL95BL9B1','5BL9B1','5

发现数据库服务器硬盘空间又报警了,已利用到了 87% ,(使用监控软件:HOBBIT) 后发现主要的大文件为:ORACLE 中的UNDOTBL1.DBF,已达到了24G. 计划重新建立UNDO表空间,删除旧的大UNDO . create undo tablespace undotbs2  datafile  '/u01/oracle/oradata/orcl/undotbs02.dbf' SIZE

[A]数据库服务器字符集select * from nls_database_parameters，其来源于props$，是表示数据库的字符集。 　　 　　客户端字符集环境select * from nls_instance_parameters,其来源于v$parameter， 　　 　　表示客户端的字符集的设置，可能是参数文件，环境变量或者是注册表 　　 　　会话字符集环境 sel

<br />1.解决跳过验证，自动登录VSS问题<br /> <br />①控制面板-->用户管理-->点击用户-->左侧：管理我的网络密码-->点击进入删除所要连接的IP<br />②在cmd中输入net use /delete *,选择Yes，即可。

1.查询系统directories select * from dba_directories

with view1 as(select ym,cgicode,ncicvtpric from(select to_date(stockyear || '-' || stockmonth,'yyyy-mm') ym,st.cgicode,sum(nvl(st.vtexceupric,0)*nvl(qty,0)) ncicvtpricfrom stocklist st where st.cgicode in (select cgicode from t_tmp) and dc = 1group by stoc

1.linux下查看占用空间 df -h2.gzip 压缩文件 gzip xx.dmp xx.dmp.gz

#! /bin/bash HOST=10.14.96.14 FTP_USERNAME=INVFTPGO03 FTP_PW=INVFTPGO03P #HOST=192.168.140.1 #FTP_USERNAME=bmsncic #FTP_PW=bmsncic DATE=$(date +%Y%m%d) KFILE=KBMS_DIPC_PRICE_$DATE.D OPARTS_FILE=ODIPC...