Tom's Guide | Tom's Hardware | Tom's Games
 |
 |
 |
I make this way it
#!/bin/csh -f
#
# Listado de codigos en produccion
#
cat > xxx$$.sql <<fin
set echo off;
set feedback off;
set pagesize 50000;
set linesize 300
column ordenador format A9;
rem
select nomb_uso,codigo,version,inf_val,estado,ordenador,taman,datesec"FECHA",control_indep
from rcodigos
where ordenador='W-HP1'
order by codigo;
rem
exit;
fin
#
sqlplus -s consulta/consulta @xxx$$ | expand > lis_hp
#
rm xxx$$.sql"La experiencia es algo maravilloso. Nos permite reconocer un error cada vez que lo volvemos a cometer.", Franklin P. Jones
0 
 |
 |
 |
This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |
