User Profile

Collapse

Profile Sidebar

Collapse
Privesh Baliper
Privesh Baliper
Last Activity: Oct 11 '10, 12:16 PM
Joined: Oct 10 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Privesh Baliper
    replied to Update and or insert
    in Oracle
    thanks, I seem to have removed the duplicate rows and it worked

    Thank you sooo much
    See more | Go to post

      Leave a comment:

    • Privesh Baliper
      replied to Update and or insert
      in Oracle
      Hi

      I'm using this:

      MERGE INTO CARDBA.DISPLAYL AYOUT A
      USING (SELECT AREACODE,
      ZONECODE,
      LOCATIONCODE,
      RECTDESTX,
      RECTDESTY,
      RECTHEIGHT,
      RECTORIGINX,
      RECTORIGINY,
      RECTWIDTH,
      TXTDESTX,...
      See more | Go to post

        Leave a comment:

      • Privesh Baliper
        started a topic Update and or insert
        in Oracle

        Update and or insert

        Hi

        I have two tables with the same structur: called DISPLAYLOAYOUT and DISPLAYLAOUT1 :

        CREATE TABLE CARDBA.DISPLAYL AYOUT - DL
        (
        AREACODE VARCHAR2(5 BYTE) NOT NULL,
        ZONECODE VARCHAR2(5 BYTE) NOT NULL,
        LOCATIONCODE VARCHAR2(5 BYTE) NOT NULL,
        RECTORIGINX NUMBER,
        RECTORIGINY NUMBER,
        RECTWIDTH NUMBER,...
        See more | Go to post
        No activity results to display
        Show More
        Working...