6 Replies Latest reply on Jun 13, 2019 5:41 AM by Jennifer Tifani

    APEX doesn't get the Default Value from DB?

    Jennifer Tifani

      Hi all,

       

      in my table I put a default value 0 NOT NULL.

       

      CREATE TABLE POST(

      ID             NUMBER(11)NOT NULL,

      NR             VARCHAR2(8)NOT NULL,

      BEZEICHNUNG    VARCHAR2(50)NOT NULL,

      IST            NUMBER(6,2) DEFAULT 0 NOT NULL,

      SOLL           NUMBER(6,2) DEFAULT 0 NOT NULL,

      DIFF           NUMBER(6,2) DEFAULT 0 NOT NULL

      )

       

      If I run this statement in SQL Developer, it will save 0 in the Columns IST, SOLL and DIFF

      insert into POST(ID, NR, BEZEICHNUNG) VALUES (SEQ_DIENID.NEXTVAL, 'AA JTD', 'von sql developer');

       

      In my APEX Application IF I didn't define any default value in those Columns, it won't get the Default Values which are already defined in the database.

       

      My question is: Do I have to set everytime the default value in each Column in APEX, even though Default Values are already set in the database?

       

      Thanks for any input.


      Best, Jennifer