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. ___ 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 |
|
|
|
| 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? |
|
|
|
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; / |
|
|
|
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; / |
|
|
|
The October developer quiz answers are: Choices 3 and 4. |
|
|
|
Upcoming events | event recaps |
|
|
|
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. |
|
|
|
|