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 Thanks, and big kudos to Michael K. for finding the bug in the January 2023 Developer Quiz answers. There is a missing left parenthesis ( in one of the “correct” answers. You can email me if you want to know the correct answer, or you can use it as an additional quiz to find the error yourself. Either way, keep the emails and feedback coming. Email me at bill.sawyer@oracle.com. | | |
|
|
|
Developer Quiz
Mark a choice as correct if "365" is displayed after execution. |
|
|
|
BEGIN DBMS_OUTPUT.put_line (300 + '65'); END; |
BEGIN DBMS_OUTPUT.put_line (300 + 65); END; |
|
|
|
BEGIN DBMS_OUTPUT.put_line (300 + 60 || 5); END;
|
DECLARE n VARCHAR2 (100) := '100'; num_of_days INTEGER := CASE WHEN n IS NULL THEN 100 ELSE '36' END || 5; BEGIN DBMS_OUTPUT.put_line (num_of_days); END; |
|
|
|
DECLARE n VARCHAR2 (100); num_of_days INTEGER := NVL (TO_CHAR (n), TO_NUMBER (36)) || 4 + '1'; BEGIN DBMS_OUTPUT.put_line (num_of_days); END; |
|
|
|
Upcoming AskTOM Office Hours
|
|
|
|
Business Innovations Webcast Series for Oracle APEX: Join us for the next live webcast with our guest, Nomura Research Institute (NRI), and learn why NRI has selected Oracle APEX to build its next-generation software and see how they managed to digitalize their processes with success and hugely reduced workload.
|
|
|
|
Share Your Thoughts about APEX Connectors: The Oracle APEX team is thinking about future connectors to APEX. We would like to know what other databases, applications, and more the APEX community is connecting to APEX currently or thinking to connect in the future. Please share your thoughts by taking this short survey!
Get your Oracle APEX Foundations Badge! Enroll in this self-paced training course to build enterprise apps 20x faster with 100x less code. Enroll in the course for free! |
|
|
|
The February developer quiz answers are:
Choices 1, 2, 4, and 5. |
|
|
|
Upcoming events | event recaps |
|
|
|
AnDOUC’s Analytics and Data Summit
Analytics and Data Oracle User Community’s Analytics and Data Summit is the premier technical conference for data analysts, data scientists and data warehouse specialists. Taking place March 14-16, 2023 at 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 and more. Don’t miss it! Register here. |
|
|
|
Oracle DevLive Level Up – Data Strategies Day (Live & On-line)
Mark March 20th-23rd on your calendars to get the most out of your data. Gain practical, technical knowledge from the experts and architects behind Oracle Database – both in learning sessions and in hands-on labs where you can try these technologies for yourself. Oracle will be sharing best practices running mission-critical databases, including document databases and unstructured data types. Discover new insights using cutting-edge analytics including AI/ML, Spatial, Graph, and Data Studio with Oracle Autonomous Database. Learn how to implement never-down applications with Oracle Maximum Availability Architecture (MAA) and how to use Oracle Database capabilities to achieve complete database security in four simple steps. Find out more and register for free at Oracle DevLive Level Up.
OUGN 2023
Don’t miss the Oracle User Group Norway’s two-day conference at Rebel Oslo, taking place April 24-25, 2023. With seven (7) inspiring tracks, fantastic food, drinks, networking, great entertainment, and a buzzing expo this is sure to great event. Ticket to OUGN 2023 are here. |
|
|
|
Learn more… for free!
Build Expertise 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
|
|
|
|
|
