This is a discussion on Prompting multiples times in PL/SQL?? within the Oracle Database forums, part of the Database Server Software category; --> The Table format is as follows: SQL> desc MyTEST; Name Null? Type ----------------------------------------- -------- ---------------------------- NAME VARCHAR2(10 CHAR) I ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| The Table format is as follows: SQL> desc MyTEST; Name Null? Type ----------------------------------------- -------- ---------------------------- NAME VARCHAR2(10 CHAR) I want to add 10 rows into this Table, with each row containing the 'name' that I want to enter. The following PL/SQL script does not work: ---------- declare i number; begin for i in 1..10 loop insert into tst (name) values ('&name'); end loop; end; ---------- It prompts for the 'name' only once and the same name figures in all the rows. But, I want to be prompted 10 times and each time I want to enter different 'name'. How exactly I should adapt the PL/SQL script for this? |