1 Reply Latest reply: Jun 5, 2013 2:29 PM by Jeff Smith Sqldev Pm-Oracle RSS

    Convert rows into Columns

    Xandot
      Please Help me!!!
      I want to convert rows into columns ,-----

      script:---

      create table jobwork (vrno varchar2(11),job_str varchar2(1000));

           VRNO     JOB_STR
            J101      J111,J112,J113,J114
            J201     J211,J222,J223,J224,J225
            J301     J311,J312
            J401     J411,J422,J423,J425,JJ426,J427

      I want output like :---

      VRNO     JOB_STR
        J101     J111
      J101 J112
      J101 J113
      J101 J114
      J201     J211
      J201 J222
      J201 J223
      J201 J224
      J201 J225
       ................................     
      and so on...........