Oracle Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___
• 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 I’m glad you enjoyed the Dec. 2022 special edition. From the readership stats, it was the most-read newsletter of the year. I hope to continue to improve this newsletter and make it a must-read resource for all things related to application development on the Oracle Database. Have thoughts or feedback? Email me at [email protected]. |
|
|
|
Developer Quiz Which choice displays “Valid JSON” after execution? |
|
|
|
| Choice 1: | | DECLARE l_json JSON_ELEMENT_T; BEGIN l_json := JSON_ELEMENT_T.parse ('{"name":123}'); DBMS_OUTPUT.PUT_LINE ('Valid JSON'); END; |
| Choice 2: | | DECLARE l_json JSON_ELEMENT_T; BEGIN l_json := JSON ELEMENT T.parse ('{"name":123}'); DBMS_OUTPUT.PUT_LINE ('Valid JSON'); END; |
|
|
|
DECLARE l_json JSON_ELEMENT_T; BEGIN l_json := JSON_ELEMENT_T.parse ('[1,2,3,4]'); DBMS_OUTPUT.PUT_LINE ('Valid JSON'); END;
|
| DECLARE l_json JSON_ELEMENT_T; BEGIN l_json := JSON_ELEMENT_T.parse '[{title:"Oracle PL/SQL Programming"},{style:"Comedy"},null, "abc"]'); END; |
|
|
|
Letters Against Isolation uses Oracle APEX to help seniors combat loneliness.
“Our volunteers have found the web platform built using Oracle APEX so intuitive and easy to use. We've seen everyone from teenagers to 80-year-olds get this lightning-fast. They really love to use it to manage their letter-writing pledges.” –Shreya Patel |
|
|
|
Submit your story and let us showcase your application!
APEX PWA Reference Oracle APEX enables developers to build progressive web apps (PWAs) that can be installed on any desktop or mobile device to deliver a more native app experience. The APEX PWA reference application serves as a reference for key features and use in your own apps. |
|
|
|
The January developer quiz answers are:
Choices 1, 3, and 4. |
|
|
|
| Upcoming events | event recaps |
|
|
|
| AnDOUC’s Analytics and Data Summit is the premier technical conference for users of analytics and data technologies in Oracle. On March 14-16, 2023 at the Oracle Conference Center in Redwood Shores, CA, there will be 40+ technical sessions and hands-on labs showcasing innovations and use cases in Oracle Autonomous Database, machine learning, spatial, graph, data lakehouses, Oracle Analytics Cloud, and more. Speakers include top Oracle product experts, customers, and partners. If you work with data and analytics, this event should not be missed! Register here . |
|
|
|
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 classes on SQL, PL/SQL, database design, logic, and more |
|
|
|
|
