06 2021 档案
摘要：cmd 直接d: 远程链接window server 的服务器 快捷键mstsc
阅读全文
摘要：insert overwrite table t_md_soft_wp7_dload partition (ds = 20120820) select g_f, dload_count, dload_user, tensoft_dload_count, tensoft_dload_user, out
阅读全文
摘要：SELECT T1.TABLE_NAME ,LISTAGG(CASE WHEN T2.DATA_TYPE = 'DATE' THEN 'TO_CHAR('||T1.COLUMN_NAME || ',''YYYYMMDD'')' ELSE T1.COLUMN_NAME END,'||''|''||')
阅读全文
摘要：#/bin/bash function recursive_list_dir(){ for file_or_dir in `ls $1` do if [ -d $1"/"$file_or_dir ] then recursive_list_dir $1"/"$file_or_dir else fil
阅读全文
摘要：1.notepad++ 替换行首、行尾空格 行首：^\s+ 行尾：\s+$
阅读全文
摘要：os.environ["ORACLE_HOME"] = '/oracle/client/12.2.0' os.environ["LD_LIBRARY_PATH"] = '$LD_LIBRARY_PATH:$ORACLE_HOME/lib'
阅读全文
摘要：find /app/dcol/cfefs -type f |xargs grep -n "215.6.9.205" find /app/dcol/markit -type f |xargs grep -n "215.6.9.205" find /app/dcol/blp -type f |xargs
阅读全文
摘要：1.使用条件查询 查询部门为20的员工列表 -- 查询部门为20的员工列表 SELECT t.DEPTNO,t.ENAME FROM SCOTT.EMP t where t.DEPTNO = '20' ; 效果： 2.使用 listagg() WITHIN GROUP () 将多行合并成一行(比较常
阅读全文
摘要：sql_item = "select rate_swap_id_sequence.nextval from (select 1 from DCS_FILE_RECORD where rownum <=%d)" % (num_data)
阅读全文
摘要：select * from dcs_reserved_rnscb0609 c where c.dcs_id in (select dcs_id from (select RANK() over(partition by zqdm, zqjc, sj, xynx, jyfs, zxjz, zxsyl,
阅读全文
摘要：select * from user_tables m where m.partitioned='YES'
阅读全文
摘要：alter table dcs_reserved_tjxt_bbo set interval(numtoyminterval(1,'month'));
阅读全文
摘要：oder by 字段 字段数据重复 rn 重复 select b.*,case when rn=1 then '保留' row_number() over(partition by order by 字段) 字段重复 rn 不重复 else '删除' end from (select RANK()
阅读全文
摘要：find 目录 *.xls > 目录/list.txt
阅读全文
摘要：# Export Oracle database tables to CSV files # FB36 - 201007117 import sys import csv import cx_Oracle connection ="dcm/Dcm_CbPc2@215.8.7.57:11521/dcs
阅读全文
