Oracle Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___
August 2022 News Highlights
• What’s New • From the Desk of the Editor • Developer Quiz • Blogs of Interest • Oracle APEX News • Upcoming Events • Learning Announcements |
|
|
|
| |
Newsletter Changes – from the desk of the Managing Editor Thanks for all the wonderful comments and suggestions. Please keep them coming. I want to make this a valuable addition to your Oracle knowledge base. Want to add your thoughts on what you want to see? Email me at bill.sawyer@oracle.com | | |
|
|
|
Developer Quiz You create the table QZ_INVOICES and index QZ_INVOICE_ORDER_DATE_I: |
|
|
|
CREATE TABLE qz_invoices ( invoice_id INTEGER NOT NULL PRIMARY KEY, order_id INTEGER NOT NULL, raised_datetime DATE NOT NULL, currency_code VARCHAR2(3) NOT NULL );
CREATE INDEX qz_invoice_order_date_i ON qz_invoices ( order_id, raised_datetime ); |
|
|
|
Which choices can go in the ##REPLACE## section, so adding the constraint will create the index QZ_INVOICE_U? | ALTER TABLE qz_invoices ADD CONSTRAINT qz_invoice_u UNIQUE ( ##REPLACE## ); |
|
|
|
order_id, raised_datetime |
|
|
|
raised_datetime, order_id |
|
|
|
| | order_id, raised_datetime, currency_code | | |
|
|
|
Upcoming AskTOM Office Hours
|
|
|
|
Oracle APEX News
Success Stories - Aspen Medical used Oracle Autonomous Database an encountered an unexpected bonus. Looking to establish a data warehouse for historic information, the company used APEX’s low-code application development to provide a rich user interface for querying legacy data, while also helping in building other applications, including a health and safety auditing system.
- Bliva cut costs by 80% while providing scalable solutions to the travel industry using Oracle Autonomous Database and APEX on OCI. Lennart Ereback, CEO, Bliva said, "By using APEX, we can quickly develop and deploy our Blieasy service. By fully leveraging APEX in combination with OCI, we can deliver functionality faster and stay ahead of our competitors."
- RD Station, a Brazilian SaaS giant, turns to OCI to solve increased storage and data processing needs created by consolidating data from multiple business areas, and using APEX helped RD Station build scalable, secure enterprise apps, which it deployed with rapid time to market.
Blogs and Videos
APEX App Creator Spotlight: APEX gives everyone the ability to be a creator and turn ideas into compelling apps. Here are some creators and the stories behind them.
- Richard Langford, founder and CEO of Innovative Systems Inc., created PeoplePay to help companies in Guyana streamline and automate payroll and other HR processes.“Users enjoy the rich functionality of Oracle APEX. The user friendliness and power of interactive reports add significant value to the system.”
- Mathias Maciel, one of Club Escuela Solidaria’s technology coordinators, used APEX to develop the CES app, which helps the school’s educators collect and store data on the academic performance of their students. “The application has a big impact because it collects data faster than the previous manual process. It’s difficult to collect useful information and to get a real projection of child performance in workshops when you are recording only with paper.”
Upcoming APEX Events: |
|
|
|
Developer Quiz
The August developer quiz answers are:
Choices 3 and 5. |
|
|
|
Upcoming events | event recaps |
|
|
|
AnDOUC TechCast Days This 3-day live virtual event has daily themes focusing on Spatial/Machine Learning and Analytics, and a special day is devoted to Data Lakehouse architectures. There are sessions for developers, DBAs, architects, and IT managers, and also include use cases from the utilities and airport industries. This is a free event.
|
|
|
|
Oracle Database World | Replays Heads up all you developers, DBAs, analysts and data scientists out there! All the latest Oracle Database World 2022 (ODW '22) presentations are now available for replay on-demand on YouTube (with no registration required)! ODW '22 was designed to help you get the most out of your data by sharing practical, technical knowledge from Oracle Database experts.
|
|
|
|
Learn more… for free!
Build Expertise with hundreds of Oracle workshops on a variety of Oracle products, 24x7 for free, on Oracle LiveLabs.
Learn, Write, and Share SQL at Oracle’s interactive Live SQL site, built with Oracle APEX running on Oracle Database.
Build Muscles at the Oracle Dev Gym by taking workouts, quizzes and even entire classes on SQL, PL/SQL, database design, logic and more. |
|
|
|
Useful links to keep your skills sharp
|
|
|
|
|
