Simple stupid question
How can I use the accept command to create a new row in my table with the data entered.
In the following example nom_etudiant is the name of the student.
accept nom_etudiant VARCHAR2(30) prompt 'Nom de l'étudiant : '
Then I want to insert his name in my table :
insert into student
(name, studentnumber, class, major)
values (nom_etudiant, 1, 3, 'A');
It doesn't work... Why ?
Here is the complete code :
-- Création d'une commmande à partir
set define on
set verify off
spool crecom.lis
prompt '*** Creer une commande ***'
prompt
accept nom_etudiant VARCHAR2(30) prompt 'Nom de l'étudiant : '
insert into student
(name, studentnumber, class, major)
values (nom_etudiant, 1, 3, 'A');
-- Fermeture du log
spool off
Thank you very much for your help!
Partager