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. ___
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 |
|
|
|
| | 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 [email protected]. |
|
|
|
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; |
|
|
|
|
|
|
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! |
|
|
|
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. |
|
|
|
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. |
|
|
|
|
