1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Updating partitioned table oracle

Discussion in 'Programming/Internet' started by user3178723, Sep 12, 2018.

  1. user3178723

    user3178723 Guest

    Hi I have a partitioned table and when I am trying to update taking few selected partition in a loop with passing partition name dynamically, it s not working.

    for i in 1..partition_tbl.count Loop

    UPDATE cdr_data PARTITION(partition_tbl(i)) cdt
    SET A='B'
    WHERE
    cdt.ab='c'

    End Loop;


    The partition_tbl object has all the partition in which I want to perform this update.

    Please suggest me how to proceed here.

    Thanks in advance

    Login To add answer/comment
     

Share This Page