Hello Application Developers, February has been an exciting month with Winter Olympics and, for those of you in the US, Super Bowl. Hope you had some time to watch and cheer on your favorite athletes. Here are some highlights of this month’s issue: New Oracle Database API for MongoDB Free technology training at the Oracle Dev Gym Latest technical best practices and how-to resources for Oracle Database, languages, low-code / APEX, Machine Learning, and more Upcoming developer events - Pi Day and Java Innovations For more insights and content, check our social media channels and other resources listed at the end of this newsletter. Kind regards, - Your Database Application Developer editor |
|
|
|
Oracle Database API for MongoDB The new Oracle Database API for MongoDB enables developers to use MongoDB APIs with Oracle Autonomous Database, including Autonomous JSON Database. The API allows you to develop and run MongoDB based applications using MongoDB tools, drivers, and frameworks directly with Autonomous Database. You can run SQL and PL/SQL that you know and love over your JSON data. You can also integrate machine learning, graph or spatial analytics, among others, into their applications—all within the Autonomous Database. Existing MongoDB applications can be migrated and run on OCI unchanged, giving you an easy way to finally get your applications running on Autonomous Database. |
|
|
|
Focused Topic: Build your technology muscles for free with the Oracle Dev Gym Did you know you can take FREE technology classes, workouts, and quizzes on SQL, PL/SQL, database design, and more? The Oracle Dev Gym offers free comprehensive on-demand classes, quick workout sessions focused on a specific technology or topic, and more than 2,500 quizzes to check your mastery level. |
|
|
|
create table qz_bricks (brick_id integer not null primary key, colour varchar2(10) not null, shape varchar2(10) not null); insert into qz_bricks values ( 1, 'red', 'cylinder' ); insert into qz_bricks values ( 2, 'blue', 'cube' ); commit; create view qz_bricks_v as select * from qz_bricks where shape = 'cylinder' with check option; |
|
|
|
Which choices run a DML statement against the view that complete successfully (without error)? 1) insert into qz_bricks_v values ( 3, 'green', 'cylinder' ); 2) insert into qz_bricks_v values ( 4, 'yellow', 'cube' ); 3) update qz_bricks_v set colour = 'blue' where brick_id = 1; 4) update qz_bricks_v set shape = 'cube' where brick_id = 1; 5) delete qz_bricks_v where shape = 'cube'; Continue reading this newsletter to find out the correct answers! |
|
|
|
Developer events March 14, 2022: Pi Day Join an online extravaganza with highly technical content and demos that developers will love. You’ll receive a free swag kit by registering, and if you’re one of the first 500 to sign up for a OCI free tier account, you can score a bonus prize. Look for the confirmation email for more details. Check out the event page(www.314piday.com)! Oracle Developer Live: Java Innovations Boost your Java skills with technical content from experts at Oracle and the Java community. For more details and registration, visit the event page. March 22, 2022 | Americas March 24, 2022 | Europe, Middle East, and Africa, Japan, Asia-Pacific Check upcoming Oracle Developer events |
|
|
|
Technology announcements Data Labeling Service V2 announcement The release induces new features, such as consolidated export file and standard export file formats, as well as several UX and UI enhancements and fixes. – Praveen Patil Replays: Oracle Database World Access Oracle Database World on demand! Discover how Oracle’s latest database innovations can help you create a data-driven organization. |
|
|
|
Get your hands dirty… for free! Get Autonomous Database for Free: 1. Oracle Cloud Free Tier plus 30-day free trial 2. $300 in credits for Cloud services Get hands-on experience on hundreds of Oracle solutions 24x7, for free on Oracle LiveLabs. Learn, Write, and share SQL at a free interactive Oracle Live SQL site, built with Oracle APEX running on Oracle Database. |
|
|
|
|