Oracle Database 23c: The Next Long Term Support Release
The new version of the world’s most powerful database, Oracle Database 23c, is now Generally Available on OCI Oracle Base Database Service. We’ve also taken the opportunity to update the popular Oracle Database Free version, available for download here. |
|
|
|
From the Desk of the Editor
Here is the October edition of the App Dev newsletter. This is our chance to highlight the latest stories to keep you updated on-the-go. We love to have your feedback and what else you want to be included in this newsletter. You can always email us with feedback, suggestions, comments, and corrections at bill.sawyer@oracle.com and priya.p.sharma@oracle.com. | | |
|
|
|
How to compare two tables to get the different rows with SQL
Read this blog to know how to see if two tables have the same data content with SQL. For example, to check data loads worked, verify query changes return the same data or see what’s changed recently.
Read more! |
Calculate the longest & current consecutive streaks with Oracle SQL
Read this blog to know about how to calculate the longest and current consecutive streaks with Oracle SQL.
Read more! |
PL/SQL JSON constructor support for aggregate types
Read this blog to know more about the enhancements to the PL/SQL JSON constructor. Bookmark this page to learn an Oracle Database 23c feature every week.
Read More! |
|
|
|
| | Developer Quiz
Which of the following choices name a built-in function that can be used to remove characters from the front of a string? |
|
|
|
| Answer 5 TRIM_LEADING | | Answer(s) are below. | | | | Oracle APEX News |
|
|
|
Oracle APEX App Deployments made easy: Use the ORDS REST APIs
Every APEX developer knows how to export and import applications using the Application Builder. And since an APEX export file is actually a SQL script, it's also pretty obvious, that one can use SQL*Plus or SQLcl to deploy the application on the target system. Read this blog post to know more. | | | | The Oracle APEX Developer Professional 2023 Certification is here! The all-new upgraded Oracle APEX certification has finally arrived. Stand out among your peers, and prove to everyone that you know how to rapidly build robust apps using APEX. Get more details about this certification here: APEX Developer Professional Certification. | | | | 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! | | |
|
|
|
POUG Conference
Poug – Pint with Oracle users group is one of the two official Oracle groups in Poland. Scheduled for November 17th – 18th at Warsaw, it is gathering of about 400 active and committed to the case members – from beginners to the experts from the Oracle field. |
|
|
|
| Learn, network and discover at the UK Oracle User Group Conference on 15th and 16th November, at Reading, UK. Plus enjoy food, drink, entertainment and networking on 15th November, evening to celebrate 40 years of OKUG. |
|
|
|
DOAG Conference
Engage with keynote speakers, attend exciting theme days such as Data for AI, Migration and Upgrade and Database Compliance and training days on Oracle Data Guard, Oracle Backup and Recovery and many more at the DOAG conference taking place from November 21st to November 24th, 2023 at Nuremberg. |
|
|
|
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 Oracle Dev Gym by taking workouts, quizzes and even entire classes on SQL, PL/SQL, database design, logic and more.
SQuizL, have fun and solve SQL quizzes. |
|
|
|
|
