APEX

In yesterday's Zoom meeting (What’s New in APEX 24.2 – Part 1), the presenter demonstrated creating a schema for a volleyball tournament. Is there a link for the generated code?

In the Oracle blog here , I have some concerns with the generated output

1. password is in plain text. This is a Bad Idea™
2. row_version really should have a default value defined in the DDL.
   • default on null 0 for DBs that support it.
   • set within the trigger otherwise
3. why is nvl( :old.row_version, 0) being used on a not null column ??
4. updated_by should be set with a function call in order to conform to DRY
5. student_id is shown in the code but not the image. how did it get there?