User Profile

Collapse

Profile Sidebar

Collapse
himanshupancholi
himanshupancholi
Last Activity: Mar 27 '08, 02:46 PM
Joined: Mar 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • himanshupancholi
    replied to Copy all values of a column from one table to another
    in Oracle
    I will re-phrase the problem. If there are multiple entries of VEND in STL_GRP, then first entry should be picked up.
    Now, certainly below query will not help me, as internal query returns all the VEND values not just first one. Can you suggest something?

    [code=oracle]

    UPDATE PARTNER
    SET VEND=
    (
    SELECT DISTINCT STL.VEND
    FROM STL_GRP STL, PARTNER PRT
    WHERE PRT.PARTNER_CD...
    See more | Go to post
    Last edited by amitpatel66; Mar 27 '08, 02:50 PM. Reason: code tags

      Leave a comment:

    • himanshupancholi
      started a topic Copy all values of a column from one table to another
      in Oracle

      Copy all values of a column from one table to another

      Hi,
      I need to Copy all values of a column from one table to another. Below are the details:
      Source: STL_GRP table, VEND column
      Destination PARTNER table, VEND column.

      I am using the below query which is incorrect:
      [code=oracle]

      UPDATE PARTNER
      SET VEND=
      (
      SELECT DISTINCT STL.VEND
      FROM STL_GRP STL, PARTNER PRT
      WHERE PRT.PARTNER_CD = STL.PARTNER_CD
      )...
      See more | Go to post
      Last edited by amitpatel66; Mar 24 '08, 04:55 AM. Reason: code tags
      No activity results to display
      Show More
      Working...