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

    Split a column into two

    Priyanka Pandey

      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.

      Regards

      Priyanka