View Detailed Profile
APEX09.SQL01: Modify data.  Use UPDATE & ROLLBACK commands and LOWER() & UPPER() functions.

APEX09.SQL01: Modify data. Use UPDATE & ROLLBACK commands and LOWER() & UPPER() functions.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX09.DB01: Change the display format of data without changing the underlying data.

APEX09.DB01: Change the display format of data without changing the underlying data.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX09 of 30: Add data to a static or a dynamic LOV.  Clean data. Enforce lowercase in a form.

APEX09 of 30: Add data to a static or a dynamic LOV. Clean data. Enforce lowercase in a form.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX 19.1 09 Add data to a static or a dynamic LOV.  Clean data and enforce lowercase in a form.

APEX 19.1 09 Add data to a static or a dynamic LOV. Clean data and enforce lowercase in a form.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX06.SQL01: The SQL code for a report’s source code is shown and explained.

APEX06.SQL01: The SQL code for a report’s source code is shown and explained.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX08.SQL01: SQL coding for a dynamic list of values (LOV) in Shared Components.

APEX08.SQL01: SQL coding for a dynamic list of values (LOV) in Shared Components.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX17 of 30:  Use UPDATE to clean data.  Add a unary relationship to a table.  Remove a column.

APEX17 of 30: Use UPDATE to clean data. Add a unary relationship to a table. Remove a column.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX12.SQL01: Create LOVs that use more than 1 table and combine 3 columns into one display column.

APEX12.SQL01: Create LOVs that use more than 1 table and combine 3 columns into one display column.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX16 of 30:  Add LOVs to a master-detail form.  Use application URL as an end-user.

APEX16 of 30: Add LOVs to a master-detail form. Use application URL as an end-user.

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files

APEX03.SQL01:  SQL commands to create tables, constraints, sequences, and triggers

APEX03.SQL01: SQL commands to create tables, constraints, sequences, and triggers

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files