This discussion is archived
5 Replies Latest reply: Jan 16, 2013 11:04 AM by Andreas Weiden RSS

Tabular form query using column values delimiter

619741 Newbie
Currently Being Moderated
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.

Requirement:-
-------------------
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
PrimaryCol SecCol
AB1 IN
AB2 IN
AB3 OUT
AB4 IN
AB5 ON

Then I will update the columns accordingly.

Please help me.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points