Nov 2022

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

What’s new

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.

Blog Posts of Interest

Upcoming AskTOM Office Hours

Check the AskTOM Office Hours page for more AskTOM office hours in November and beyond!

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!

Blogs and Videos

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.

Useful links to keep your skills sharp

Blogs:Oracle Developers | Oracle Database Insider | Oracle APEX

Websites:Oracle Database | Oracle Autonomous Database | Oracle Developer Center | Oracle Apex

Keep in touch

This email was sent to you because you subscribed to this newsletter.