APEX 19.1 17 Use UPDATE to clean data. Add a unary relationship to a table. Remove a column.

Опубликовано: 30 Октябрь 2024
на канале: J Kreie Database
2,048
14

If the http://db.kreie.net URL doesn't work, go to this website to access the scripts and other files used in this video series. https://sites.google.com/view/db-krei...

Fix some errors Clean up data in the ANIMALS table (change Dog to Canine). Use the “SQL Commands” feature in SQL Workshop for this and use the UPDATE command. Remove a column from a table. Add a unary constraint to the EMPLOYEES table (a referential relationship between two columns in the same table). Import the data dictionary (data model) using SQL Developer.