Oracle Visual Builder: Applications That Outlive Their First Release · Module 5 · Data: business objects and external services
Importing and exporting data
Lesson 49 of 176 · 3 min
Getting rows IN and OUT, and WHAT HAPPENS TO RELATIONSHIPS WHEN YOU DO. Import and export sound like administrative conveniences and are the two operations most likely to put wrong data into a table nobody checks. IMPORT IS THE ONE WITH TEETH, AND THE FIRST THING TO KNOW IS WHAT IT DOES ABOUT DUPLICATES. Run it twice and you either have two copies of everything or one, depending on whether the tool is matching on something. Establish which BEFORE you import into a table that already has rows — the first import into an empty table is safe and teaches you nothing. THE RELATIONSHIP PROBLEM IS THE REAL ONE, AND IT IS AN ORDERING PROBLEM. A row that points at another row needs the other row to exist first. Import the children before the parents and every reference is broken — and depending on the configuration that is either an…
The full lesson is part of the course
The video, the complete written lesson and the module quiz are included in Oracle Visual Builder: Applications That Outlive Their First Release, with a certificate on completion and a fourteen-day refund window.
In this module: Module 5 · Data: business objects and external services
- 1Business objects: your own database
- 2When to keep data here, and when not to
- 3Designing a business object
- 4Object rules and triggers
- 5Importing and exporting data
- 6The endpoints your objects expose
- 7External services: the other half
- 8Reference data and lookups
- 9What breaks: three data failures
- 10Lab briefing · Two sources, one screen