Forum Programmation.shell Aide synthax shell pourle "case"
file_sql=requete.sql path_sqlplus=/exec/products/oracle/v10.2.0/bin ORACLE_BASE=/exec/products/oracle ORACLE_SID=RMSPOW1 database=$ORACLE_SID ORACLE_HOME=/exec/products/oracle/v10.2.0 #TIMESTAMP Thu Jan 18 19:28:25 NFT 2007 JOURSEMAINE=`date |cut -c 1-3` #Thu MOIS=`date |cut -c 5-7` #Jan JOUR=`date |cut -c 9-10` HEURE=`date |cut -c 12-13` #MINUTE echo "Exécution du fichier contenant la requete" echo "test" $JOURSEMAINE $MOIS $JOUR $HEURE # $path_sqlplus/sqlplus $user/$password #$path_sqlplus/sqlplus $user/$password@$database $file_sql #VALUE=`sqlplus -silent "/ " <(…)