SQL & PL/SQL

Dear all,

I’m trying do modify an existing program launched with SQL plus.

This program allows me to display (in a csv file) a table according a model number. Thanks the command « accept nof prompt 'Numero OF :' » I can prompt the user to tap the model number that he wants to display and the rest of the program create the list in the csv file.

The modification I want to do is as follow:

I’d like the user to be able to enter multiple model number (for exemple: 55125,55126,54672) instead of just typing one, get the csv file, copy/paste the result and execute the program with another model number.

The program should be able to display all the list one after the other.

The question is, how can I do that ?

I also think about another solution, the program prompt the user to enter a model number, write it in the csv file, prompt the user to enter an other model number, write it, etc. and stop writing when the user tap “exit”.

Thank you very much for your precious help, I’m a beginners with sql and I do not know very well how to use “IF” sequence and use the data input by the user.

My program is:

set serveroutput on
set termout on

accept nof prompt 'Numero OF :'

spool c:\temp\ext_prix.csv

set serveroutput off
set termout off
set heading off
set pagesize 0
set echo off
set trimspool on
set feedback off

select REOF_RESS_CODE || ';' || 
 to_char(REOF_PHOF_NUMERO_PHASE) || ';' || 
 translate(to_char(nvl(REOF_TPS_PASSE,0)),'.','.') || ';' || 
 translate(to_char(nvl(REOF_MT_PASSE,0)),'.','.')
from ressource_of
where reof_orfa_numero = '&nof'
union all
select stmv_arti_code || ';' || 
 arti_designation || ';;' || 
 translate(to_char(stmv_prix_unitaire_ue * beof_qte_besoin_ue),'.','.')|| ';;' || 
       BEOF_QTE_BESOIN_UE|| ';;' || 
       BEOF_CUMUL_QTE_SORTIE_UE
from   stock_mouvement, article , besoin_of
where  arti_code        = stmv_arti_code
and    stmv_orfa_numero = '&nof'
and stmv_nmst_code   in ('OF-SOR-CPT','OF/SOR/CPT')
and STMV_CENT_CODE   != 'ELEC'
and beof_orfa_numero  = stmv_orfa_numero
and    beof_arti_code    = stmv_arti_code
group by stmv_arti_code,
         arti_designation,
         stmv_prix_unitaire_ue,
             BEOF_QTE_BESOIN_UE,
             BEOF_CUMUL_QTE_SORTIE_UE
;

spool off
exit

And the csv files look like:

Thank you very much in advance.