Oracle APEX - Stop Primary Key Default Value 't1000' on Page

3
votes

I'm using Oracle APEX Page Designer. I have a master detail page. For both the master and the detail sections, the page defaults the value of the primary key to 't1000' every time I insert a new record. If I insert more that one new record, it increments the number.

  • I do not have a sequence tied to the value in the table definition.
  • When inserting in SQL workshop, no default value is shown
  • On page, Default value is set to "SQL Query" with query of "select null from dual"

I want the new records to be blank.

1
oracle-apex
Did you try removing the default value? – Anuswadh

1 Answers

1
votes

To avoid t1000 in your Master Detail Page or Interactive Grid, you can use ROWID as primary key.

Take a look at this example:

ROWID as Primary Key