5 Replies Latest reply: Jan 16, 2013 1:04 PM by Andreas Weiden RSS

    Tabular form query using column values delimiter

    Nel Marcus
      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.