Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Angry Unanswered: update statement for sp

    I have a table that needs to be edited based on 2 input parameters in the table. This is what I've come up with so far. Please tell me if I'm on the right track.

    update g.pbd
    set pbd_number = x, pbd_title = y
    (select pbd_id
    from g.pbd)
    where pbd_number = pbd_number and pbd_title = pbd_title;

    Thanks

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I'm on the right track.
    No
    >g.pbd
    from where in the world did the "g." come out of the blue?
    >select pbd_id
    please explain why you are selecting this field?
    >set pbd_number = x, pbd_title = y
    How/where to "x" & "y" get defined or any value?
    Rather than doing...
    Ready, Fire, Aim
    Please try to RTFM
    http://download-west.oracle.com/docs...8a.htm#2068178
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •