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
October 2022
Database Application Developer Newsletter

Oracle Database Application Developer Newsletter

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

October 2022 News Highlights

•   What’s New
•    From the Desk of the Editor
•    Developer Quiz
•    Blogs of Interest
•    Upcoming AskTOM Office Hours
•    Oracle APEX News
•    Upcoming Events
What’s new
 

From the desk of the Editor
As you are reading this, Oracle CloudWorld has wrapped up. You can look forward to lots of content from it in future newsletters. I continue to see great interaction with and questions on the Developer Quiz. Keep them coming. Want to add your thoughts on the Developer Quiz, newsletter content that you want to see, or other changes to recommend? Email me at bill.sawyer@oracle.com.
 
Developer Quiz
You create this table:
CREATE TABLE plch_employees
(
   employee_id      INTEGER,
   last_name        VARCHAR2(100),
   salary           NUMBER DEFAULT0,
   commission_pct   NUMBER DEFAULT NULL
)
/
Which of the choices will display "1" after execution?
Choice 1:
Choice 2:
BEGIN
     INSERT INTO plch_employees
           VALUES (100, 'Persnickety');
     DBMS_OUTPUT.put_line (SQL%ROWCOUNT);
END;\
/
BEGIN
  INSERT INTO plch_employees
    VALUES (last_name => 'Persnickety', employee_id => 100);
DBMS_OUTPUT.put_line (SQL%ROWCOUNT);
END;
/
Choice 3:
Choice 4:
BEGIN
   INSERT INTO plch_employees
      VALUES (100,'Persnickety',100,10);
   DBMS_OUTPUT.put_line (SQL%ROWCOUNT);
END;
/
BEGIN
   INSERT INTO plch_employees
         (employee_id, last_name)
       VALUES (100,'Persnickety');
    DBMS_OUTPUT.put_line (SQL%ROWCOUNT);
END;
/
Answer is below.
 
 
AskTOM
 
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.  

  • Mathias Maciel of the Club Escuela Solidaria in Paraguay used his background as a software developer to create the CES app using Oracle APEX that educators use to help students and parents improve performance in their school workshops.
  • Submit your story and let us showcase your application! 

Blogs and Videos 
 
 
 
 
The October developer quiz answers are:

Choices 3 and 4.
 
Upcoming events | event recaps
Upcoming APEX Events: 

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.
Oracle APEX Foundations
Free Hands-on
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.
 

Keep in touch
 
Facebook
 
Twitter
 
YouTube
 
LinkedIn
Terms of Use and Privacy | Un‌subscribe | Contact Us
This email was sent to you because you subscribed to this newsletter.
Copyright © 2022, Oracle and/or its affiliates. All rights reserved. Oracle Corporation - Worldwide Headquarters, 2300 Oracle Way, Austin, TX 78741, United States
Oracle