Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Help with Update if record exists else insert record "upsert"

771751Jul 25 2012 — edited Jul 26 2012
Hi Friends,
i have this table:
CREATE
  TABLE TB_GEN_COMPANY
  (
    "ID_COMPANY"   NUMBER NOT NULL ENABLE,
    "COD_CODIGO"    VARCHAR2(10 BYTE) NOT NULL ENABLE,
    "DES_NAME"    VARCHAR2(64 BYTE) NOT NULL ENABLE,
    "DES_DIRECTION" VARCHAR2(128 BYTE) NOT NULL ENABLE,
    "COD_RUC"       CHAR(11 BYTE) NOT NULL ENABLE,
    "FLG_EST"    CHAR(1 BYTE) NOT NULL ENABLE,
    "COD_USR_CR"  VARCHAR2(16 BYTE) NOT NULL ENABLE,
    "FCH_FEC_CR" TIMESTAMP (6) NOT NULL ENABLE,
    "COD_USR_MOD" VARCHAR2(16 BYTE) NOT NULL ENABLE,
    "FCH_FEC_MOD" TIMESTAMP (6) NOT NULL ENABLE,
    CONSTRAINT "TB_GEN_COMPANIA_ESTADO_CHK" CHECK (FLG_ESTADO IN ('A', 'I'))
    CONSTRAINT "TB_GEN_COMPANIA_PK" PRIMARY KEY ("ID_COMPANIA")
  )
I want to validate the code (cod_codigo). if the record exists, i will have to update with the news inputs parameters, otherwise it should create a new one i mean, an Insert.

Thanks for t he help.

Sorry for bad engl.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2012
Added on Jul 25 2012
9 comments
3,606 views