September 2022

Oracle Database Application Developer Newsletter

Technical news, how-to articles, best practices, and more.

___

September 2022 News Highlights

• What’s New

• From the Desk of the Editor

• Developer Quiz

• Blogs of Interest

• Oracle APEX News

• Upcoming Events

• Learning Announcements

What’s new

Newsletter Changes – from the desk of the Managing Editor

In this issue, we get you ready to prepare and plan for Oracle CloudWorld, along with the news and every popular Developer Quiz. Want to add your thoughts on what you want to see or have other changes to recommend? Email me at bill.sawyer@oracle.com.

Developer Quiz

You create a table and start writing an anonymous block to populate it:

CREATE TABLE qz_bricks (

brick_id INTEGER NOT NULL PRIMARY KEY,

colour VARCHAR2(10) NOT NULL,

shape VARCHAR2(10) NOT NULL

);

DECLARE

##REPLACE##

BEGIN

brick.brick_id := 1;

brick.colour := 'red';

brick.shape := 'cylinder';

INSERT INTO qz_bricks

VALUES brick;

END;

Which choices can go in the ##REPLACE## section, so the block executes without error?

Choice 1:

TYPE brick_rec IS RECORD (

brick_id INTEGER,

colour VARCHAR2(10),

shape VARCHAR2(10)

);

brick brick_rec;

Choice 3:

TYPE brick_rec IS RECORD (

brick_id NUMBER(1),

colour VARCHAR2(1),

shape VARCHAR2(1)

);

brick brick_rec;

Choice 5:

brick qz_bricks%ROWTYPE;

Answer is below.

Choice 2:

TYPE brick_rec IS RECORD (

brick_id NUMBER,

colour VARCHAR2(4000),

shape VARCHAR2(4000)

);

brick brick_rec;

Choice 4:

TYPE brick_rec IS RECORD (

brick_id NUMBER,

colour VARCHAR2(10),

shape VARCHAR2(4000)

weight NUMBER

);

brick brick_rec;

Blogs of Interest

Upcoming AskTOM Office Hours

For more AskTOM office hours in September and beyond,

check the AskTOM Office Hours page.

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.

Pablo Duque developed the NeuroBaseapp to provide neurorehabilitation experts one place to go to assess cognitive and behavioral data. “NeuroBase allows us to standardize the data we collect,” says Duque. “APEX gave us the flexibility we needed to build an app that allows neurorehabilitation specialists, like myself, to achieve more, more easily.”
Submit your story and let us showcase your application!

Blogs and Videos

Developer Quiz

The August developer quiz answers are:

Choices 1, 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.

View the agenda and register.

Upcoming APEX Events:

Modernização de Projeto Oracle Forms para Oracle APEX (September 22)
Oracle APEX: lo sviluppo applicativo low-code visto dagli utenti (September 28)
What’s new in Flows for APEX v22.2 (September 29)
SPOUG Academy: LowCode Development (October 5)
APEX at Oracle CloudWorld 2022! (October 17-20)

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.