4 Replies Latest reply: Mar 27, 2015 5:01 AM by Priyanka Pandey RSS

    Split a column into two

      Hi Team,


      I have a table containing three fields STUDENT, TYPE and MARKS.


      I need to split Column TYPE in to two columns i.e.. SUBJECT and  EX_TYPE


      SUBJECT column will contain PAPER-I, PAPER-II, PAPER-III and so on.

      EX_TYPE column will contain INTERNAL, EXTERNAL, PRACTICAL etc.


      Can any one help me out of this problem.