Skip to Main Content
Feature Request FR-2821
Product Area SQL Workshop
Status CLOSED

11 Voters

Add a Quick SQL "Add Primary Key" option of APEX_GUID

anton nielsen Public
· Oct 28 2022

Idea Summary
Add a new “Add Primary Key” option: APEX_GUID.

Using APEX_GUID would add the following into the generated trigger (the second line in the code below):

if inserting then
:new.id := coalesce(:new.id, wwv_flow_id.next_val); -- or better still create another synonym apex_id
:new.created := sysdate;
:new.created_by := coalesce(sys_context('APEX$SESSION','APP_USER'),user);
end if;

Use Case
The way that APEX generates IDs is great. Let the rest of us do it the same way APEX does--with no work.

Preferred Solution (Optional)
Add this into the next release of Quick SQL :)

We reviewed this idea carefully, and while it was interesting, we concluded that due to all the internal implications we need to take into account, it is unlikely to make its way into APEX.

Comments

Comments

  • vincent morneau Admin OP 2 years ago

    Hi @anton nielsen ,

    I wanted to provide an update regarding this idea. In the future, Quick SQL will be developed by the database tools team, which means that this particular idea will not be implemented in the current Oracle APEX implementation. Your idea has been forwarded to the database tools team as they continue to develop Quick SQL.

    Thank you for taking the time to post this idea and we are looking forward to see it implemented in the next Quick SQL version.