Hi All,
I have a table with two columns.
create table wordsAndMeanings
(word varchar2(50),
meaning varchar2(250)
);
insert into wordsAndMeanings(word) values('Ambivalent');
insert into wordsAndMeanings(word) values('Ubiquity');
commit;
Now I want to Update the meaning column for each word which is a pretty straight update statement.
But, I want to provide the word to the user and ask him to enter the meaning of it. The value he entered would be stored in the respective row.
Something like this:
Word is : Ambivalent
Please write the meaning:(Here user should write whatever he feels is the answer)
It should ask for all the rows, which is a for loop on select cursor. So that is fine.
How to achieve this prompting thing.
P.s: I don't want that 'Enter value for' thing coming here. It should be exactly as mentioned above.