> : 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?
>
> Did this really take three posts to get posted?
There seems to be some problem in Google groups server. From last week
onwards, if I do the posting once, it appears thrice in the news
server. Truly, it was not my fault.
> This is a single block of code. sql*plus doesn't run it ten times, in
> fact sql*plus doesn't run it at all, ever. sql*plus simply gathers
> together the text of the block. It does that just once as it reads it.
> To finalize the text of the block it needs the &name value so it asks for
> it.
>
> Then it sends the complete, finalized block to the server, which runs it
> (just once, though that "one run" includes a loop with ten iterations).
Thanks for the clarification. It helps!
Received on Fri Jun 23 2006 - 00:20:51 CDT
