sqlplus FYTR_$1\/fy$1 < $0.txt
\nSET echo off
\nSET termout off
\nSET feedback off
\nSET linesize 530
\nSET trimspool on
\nSET pagesize 0
\nSET colsep ‘;’<\/p>\n
spool \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp
\nselect ‘NUM_OF;STATUT_OF;DT_CREAT;DT_LANC;DT_SOLDE;MOIS;SITE;CENTRE;CODE_ARTICLE;LIBELLE_ARTICLE;QTE_LANC;QTE_LIVR;P_UNI_MAT;P_UNI_TAF;P_UNI_MO;P_UNI_TOT;P_LAN_MAT;P_LAN_TAF;P_LAN_MO;P_LAN_TOT;REA_MAT;REA_TAF;REA_MO;REA_TOT;P_LIV_MAT;P_LIV_TAF;P_LIV_MO;P_LIV_TOT;REA_TOT-P_LIV_TOTecart_reel_std;DIRECT_STD;FRAIS_STD;STD;DT_STD;Direct_MAT;Direct_MO;Direct_TAF;Frais_MAT;Frais_MO;Frais_TAF;PRMOF;DT_PRMOF’ titre from dual;<\/p>\n
select * from VFY_CLOTURE_STD_PRMOF;
\nspool off
\nexit
\nEOSQL<\/p>\n
rm $0.txt
\n# suppression des lignes SQL
\ngrep -v SQL \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp > \/rmanbackup\/octal\/extraction\/cloture_std_prmof_$1.csv<\/p>\n
#rm \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp<\/p>\n
vtcopy -i \/rmanbackup\/octal\/extraction\/cloture_std_prmof_$1.csv -o e:\\\\exploitation_vtom\\\\extraction_octal\\\\<\/p>\n
exit 0<\/p>\n","protected":false},"excerpt":{"rendered":"
sqlplus FYTR_$1\/fy$1 < $0.txt SET echo off SET termout off SET feedback off SET linesize 530 SET trimspool on SET pagesize 0 SET colsep ‘;’ spool \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp select ‘NUM_OF;STATUT_OF;DT_CREAT;DT_LANC;DT_SOLDE;MOIS;SITE;CENTRE;CODE_ARTICLE;LIBELLE_ARTICLE;QTE_LANC;QTE_LIVR;P_UNI_MAT;P_UNI_TAF;P_UNI_MO;P_UNI_TOT;P_LAN_MAT;P_LAN_TAF;P_LAN_MO;P_LAN_TOT;REA_MAT;REA_TAF;REA_MO;REA_TOT;P_LIV_MAT;P_LIV_TAF;P_LIV_MO;P_LIV_TOT;REA_TOT-P_LIV_TOTecart_reel_std;DIRECT_STD;FRAIS_STD;STD;DT_STD;Direct_MAT;Direct_MO;Direct_TAF;Frais_MAT;Frais_MO;Frais_TAF;PRMOF;DT_PRMOF’ titre from dual; select * from VFY_CLOTURE_STD_PRMOF; spool off exit EOSQL rm $0.txt # suppression des lignes SQL grep -v SQL \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp > \/rmanbackup\/octal\/extraction\/cloture_std_prmof_$1.csv #rm \/rmanbackup\/octal\/extraction\/cloture_std_prmof.tmp … Continuer la lecture de « Exemple .SH pour g\u00e9n\u00e9rer un .CSV »<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[51],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/15"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}