1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to update field in four constrained tables

Discussion in 'SQL PL/SQL' started by SlaYerSX, May 6, 2013.

  1. SlaYerSX

    SlaYerSX Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Hi all!
    I need to distort the c_main_v_id field in test banking oracle datebase

    We can select it by query

    select a.c_main_v_id
    from z#depn d,
    z#ip_accounts ia,
    z#ac_fin a,
    z#ip_cards ic
    where d.c_account = a.id
    and ia.c_prod_ref = d.id
    and ic.c_ip_accounts_ref = ia.id


    So how we can distort c_main_v_id in all these tables?
     
  2. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Can you please explain abit more about the requirement.
     
  3. SlaYerSX

    SlaYerSX Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    The task is not actual, ty.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Then why ask? You use terms improperly (in my opinion) as you don't define exactly what you mean.

    "So how we can distort c_main_v_id in all these tables?"

    This means what, exactly? Or is this nothing more than trolling the newsgroup for responses to your ill-conceived question? I think it's the latter due to this:

    "The task is not actual, ty."

    So what IS the task?