News on JavaOne, how to add geospatial to your apps, get OCI DevOps certification, read the latest best practices and how-to resources, and more.
Oracle Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___
November 2022 News Highlights
• What’s New • From the Desk of the Editor • Developer Quiz • Blog Posts of Interest • Upcoming AskTOM Office Hours • Oracle APEX News • Upcoming Events • Learn more… for FREE |
|
|
|
| | From the desk of the Editor Oracle CloudWorld 2022 was a great success. In this month, and the months to follow, you will be seeing some of the great content from that event. There are some awesome updates that every Oracle Database developer needs to know. Even if the updates don’t affect you now, they are great to know for future projects. Keeping sending your feedback and thoughts on how to make this newsletter better. Email me at [email protected]. |
|
|
|
Developer Quiz – Is the table empty? I execute this statement |
|
|
|
| CREATE TABLE plch_data (n NUMBER) / |
Which choices display "Empty table!" after execution? |
|
|
|
| Choice 1: | | DECLARE l_n NUMBER; BEGIN SELECT n INTO l_n FROM plch_data; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line ('Empty table!'); END; / |
| Choice 2: |
BEGIN UPDATE plch_data SET n = 1; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line ('Empty table!'); END; / |
|
|
|
| Choice 3: | | BEGIN DELETE FROM plch_data WHERE n = 1; EXCEPTION WHEN NO_DATA_FOUND THEN DBMS_OUTPUT.put_line ('Empty table!'); END; / | | Answer is below. |
|
|
|
Oracle APEX News
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.
Christina Moore, founder of Storm Petrel, LLC emergency management consulting services, used Oracle APEX to help agencies and organizations track the requirements for financial recovery following natural disasters.
Submit your story and let us showcase your application! |
|
|
|
The November developer quiz answers is:
Choice 1. |
|
|
|
Upcoming events | event recaps
Oracle APEX: Foundations Learning Path is now available!
Announcing the release of the Oracle APEX Foundations Learning Path with Oracle University. This self-paced course can be taken at your convenience and pace and is FREE! Once you complete the course, you will receive a badge from Oracle. |
|
|
|
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. |
|
|
|
|
