I wanted to know, if i can query a tabular block by entering the column values (primary key) as semicolon delimited and update required fields. Please let me know.
User will enter 5 values as "AB1; AB2; AB3; AB4; AB5"
After entering I need to write a plsql code to query the tabular form as follows
Then I will update the columns accordingly.
Please help me.
Sorry, i don't have my crystal ball with me. You will have to provide information about what "It's not working" means. Do you get any error? Doesn't it retrieve data? Wrong data?
You might also test this in sql*plus.