Database Application Developer Newsletter Technical news, how-to articles, best practices, and more. ___ July 2022 News Highlights • Latest database app dev best practices and how-to resources • Reference architecture for adding location intelligence to your applications • New OCI DevOps Professional Certification • How Oracle internal teams are developing apps using Oracle • Upcoming Oracle CloudWorld |
|
|
|
Newsletter Changes – from the desk of the Managing Editor The Database Application Developer Newsletter is changing. This is the first newsletter of that change, and you probably don’t notice much difference. It’s true. Slight tweaks from previous editions, but this one is not too different. BUT! Change is coming. Change to make it better, and more relevant to the topics and news you need. My name is Bill Sawyer, and I am joining as Managing Editor. I have been planning some exciting changes. But, this doesn’t have to be a one-way conversation. Do you have thoughts on what you want to see? Email me at bill.sawyer@oracle.com |
|
|
|
Developer quiz You execute these statements: |
|
|
|
##REPLACE## insert into ora$ptt_invoice_stage values ( 1, 1 ); commit; select * from ora$ptt_invoice_stage; |
|
|
|
Which choices can go in the ##REPLACE## section, so the query returns this row? |
|
|
|
ORDER_ID CUSTOMER_ID ---------- ----------- 1 1 |
|
|
|
create table ora$ptt_invoice_stage ( order_id integer, customer_id integer ); |
create global temporary table ora$ptt_invoice_stage ( order_id integer, customer_id integer ) on commit preserve rows; |
|
|
|
create private temporary table ora$ptt_invoice_stage order_id integer, customer_id integer ); |
create private temporary table ora$ptt_invoice_stage ( order_id integer, customer_id integer ) on commit preserve definition; |
|
|
|
Code You Can Use Martin Bach wrote a nice piece titled, Generating Table DDL in Oracle Database. This blog showcases how you can easily generate DDL statements using SQLcl 22.1.1.0 connecting to a 19c Autonomous Transaction Processing. There are lots of new features in SQLcl 22.1.1.0, and this is some code you probably want to keep in your bookmarks. If you want to know more about SQLcl 22.1.1.0, check out Jeff Smith’s blog post, Oracle SQLcl 22.1 is now available & featuring Data Guard!, on the topic. Tools You Can Use Daniel Cuadra gives you the latest on Oracle Spatial Studio in his blog, Upgrading to Oracle Spatial Studio 22.1. Oracle Spatial Studio provides no-code access to spatial data preparation, analysis and visualization. It allows you to work with data already in Oracle Database or load from common spatial and non-spatial formats. Non-spatial data can be prepared by address geocoding or coordinate indexing and then used for spatial analysis and mapping. Results may be shared as interactive maps as well as GeoJSON endpoints for programmatic integration. |
|
|
|
Developer Success Story Pablo Duque’s NeuroBase helps neurorehabilitation experts improve the patient experience. Neurorehabilitation is a physician-supervised program designed for people with diseases, trauma, or disorders of the brain, such as Parkinson’s disease, and it generates a lot of data. Pablo saw a need to process that data and, in his words, “There was really no good software available to do that.” So Duque made his own tool: NeuroBase using Oracle APEX. |
|
|
|
Upcoming events | event recaps Oracle CloudWorld | October 16–20, 2022, Las Vegas, NV Mark your calendar and plan on joining us in Las Vegas, NV. You can explore the latest technical innovation as well as get product demos, advanced best practices, training, and insights from Oracle experts. Subscribeto get the latest news about event registration, keynote speakers, sessions, and more. Subscribe for updates |
|
|
|
Oracle Database World – Session replays We hope those of you in Americas and EMEA enjoyed the event and got practical and technical knowledge on app dev through sessions and labs. Session replays for the America and EMEA events are now available at the event site. JavaOne at CloudWorld | October 16–20, 2022, Las Vegas, NV Get the latest on Java innovations through expert-led technical sessions, hands-on labs, tutorials, and birds-of-a-feather sessions. You can choose from dozens of topics, including Java language, Java platform, database, cloud native development, DevOps, microservices, AI and machine learning, security, application management, and more. Get JavaOne updates |
|
|
|
The July developer quiz answer is choice 4. |
|
|
|
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. |
|
|
|
|