sql 语句生成命令 和SQL

用sql语句查询结果拼接字符串命令

 

SELECT CONCAT(A.ofm_path_id,'-',A.distribute_address_id,'-',A.distribute_rule_id),A.in_file_abs_name, b.service_instance_name,b.instance_code,
CONCAT('LN -f  ',A.in_file_abs_name,'  /ogsapp/WORK/dist/inst03/DATA/',A.ofm_path_id,'-',A.distribute_address_id,'-',A.distribute_rule_id,';')
 FROM `T_SND_DISTRIBUTE_INFO_20141110` A,T_SERVICE_INSTANCE b 
WHERE A.`OUT_F_NAME`  in ('GOZZ00198029JF201411102220001Il0.jf.00.0.0.xt','GJYY00198155JF201411102255017IlE.jf.00.0.a.xt','GJYY00198103JF201411101805002CUG.jf.00.0.a.xt') AND A.SERVICE_INSTANCE_ID=b.SERVICE_INSTANCE_ID;

 

SELECT CONCAT(A.ofm_path_id,'-',A.distribute_address_id,'-',A.distribute_rule_id),A.in_file_abs_name, b.service_instance_name,b.instance_code,
CONCAT('LN -f ',A.in_file_abs_name,' /ogsapp/WORK/dist/inst03/DATA/',A.ofm_path_id,'-',A.distribute_address_id,'-',A.distribute_rule_id,';')
 FROM `T_SND_DISTRIBUTE_INFO_20141110` A,T_SERVICE_INSTANCE b 
WHERE A.`OUT_F_NAME`  ='GOZZ00198029JF201411102220001Il0.jf.00.0.0.xt' AND A.SERVICE_INSTANCE_ID=b.SERVICE_INSTANCE_ID;

SELECT DISTINCT DATA_SOURCE_ID, 
CONCAT('ssh ',SUBSTR(s.`INSTANCE_CODE`,14,LOCATE('_ogsapp',s.`INSTANCE_CODE`,14)-14)) AS 进入主机命令,
DATA_SOURCE_CODE AS 数据源编码,
CONCAT ('scp -r showlog@',SUBSTR(s.`INSTANCE_CODE`,14,LOCATE('_ogsapp',s.`INSTANCE_CODE`,14)-14),':/ogsapp/data/org/19/',DATA_SOURCE_CODE,'/201408/*/*.gz ./') 提取脚本
FROM T_GAT_DATA_SOURCE d, T_SERVICE_INSTANCE s WHERE DATA_SOURCE_ID 
IN (SELECT DISTINCT DATA_SOURCE_ID FROM T_PRE_FILE_CLASS WHERE FILE_OUT_PATTERN LIKE '019%PJZZ%' AND STATUS = 1 ) 
AND d.`SERVICE_INSTANCE_ID`=s.`SERVICE_INSTANCE_ID`;

 SQL生产SQL

select 'select count(*) from '||table_name||';' cnts from user_tables;