Post reply

PIVOT in oracle--Code Correction

  • October 3, 2011 at 11:10 am

    #243967

    select * from

    (

    select prod_code from UNICA.DSI_SUBS_STOP_START_DRW

    )

    pivot (

    count(prod_code)

    For prod_code in ('E','3','W','W5','SS','S','4','W2','WS','3S','D','FS','3T','H3','TS')

    )

    I can't make this pivot work. Can somebody correct my mistake in the code. I get "SQL command not Properly ended" error. I have a problem making PIVOT work. Does Oracle 10g support PIVOT at all ???

    Thanks.

  • October 5, 2011 at 3:02 am

    #1390541

    Not supported in 10g as it was introduced in 11g according[/url]

  • October 5, 2011 at 7:41 am

    #1390679

    Thanks..

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply