Ask TOM for Database/SQL

@[email protected]
129 Followers
0 Following
510 Posts
Ask The Oracle Mentors site. Chris Saxon and Connor McDonald help you succeed with Oracle Database
Ask TOM for Database/SQLMay 2, 2023
How you build your test cases directly impacts the chances of someone helping you
---
RT @connor_mc_d
Been a bit tardy on blogging so time to jump back on the horse! Enjoy! #database #sql
https://connor-mcdonald.com/2023/05/02/can-you-pass-the-empty-schema-test/
https://twitter.com/connor_mc_d/status/1653364524655714307
Can you pass the EMPTY SCHEMA test?

Learning is not a spectator sport
Ask TOM for Database/SQLMay 1, 2023
23c continues to get better and better
---
RT @connor_mc_d
Fresh video!
Now when your applications update data they can get both the previous and new values for the columns in a single trip to the database, all with a simple extension to the existing syntax.
#database #sql
https://www.youtube.com/watch?v=a_4Puge8hMw
https://twitter.com/connor_mc_d/status/1653087347725025292
Get both NEW and OLD values from DML RETURNING

YouTube
Ask TOM for Database/SQLApr 29, 2023
RT @connor_mc_d
Wrapping up Norway with a tip to other event organizers on logistics, the ACE program and something ominously threatening at the very end of this video :-) #ougn2023 @oracleace
Ask TOM for Database/SQLApr 29, 2023
LOTS of columns available for you in 23c
---
RT @connor_mc_d
Fresh video!
It's not for every table and every application, but more columns can be useful in special cases
#database #sql
https://youtu.be/7KS7cN2ZMwQ
https://twitter.com/connor_mc_d/status/1651830100797841409
How many columns is too many?

YouTube
Ask TOM for Database/SQLApr 18, 2023
Join us, we will be live soon! Office Hours session: OML Services Batch Scoring on Autonomous Database starts in 65mins https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:6801 #oracle #AskTOMOfficeHours
OML Services Batch Scoring on Autonomous Database

Ask TOM for Database/SQLApr 18, 2023
Join us and learn! Next session for Oracle AskTOM Office Hours: Low-Code for building an automated clinical trial oversight system - a customer story. Starts on 19 April at 15:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:19665 #oracle #AskTOMOfficeHours
Low-Code for building an automated clinical trial oversight system - a customer story

Ask TOM for Database/SQLApr 18, 2023
RT @connor_mc_d
VALUES clause.
Now with less code, and more flexibility!
#database #sql
https://youtu.be/fKTb6CfPxCk
VALUES clause gets a massive boost!

YouTube
Ask TOM for Database/SQLApr 18, 2023
Next week: Spatial for Python developers. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 25 April at 14:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:7761 #AskTOMOfficeHours
Spatial for Python developers

Ask TOM for Database/SQLApr 18, 2023
Next week: Multicloud Happenings!. Oracle experts will be online for AskTOM Office Hours. Mark your calendar. 25 April at 14:00 UTC https://asktom.oracle.com/pls/apex/f?p=100:551::::551:P551_CLASS_ID:19662 #AskTOMOfficeHours
Multicloud Happenings!

Ask TOM for Database/SQLApr 18, 2023
Often viewed on #AskTOM: Export into pre-existing schema https://asktom.oracle.com/pls/apex/asktom.search?tag=export-into-pre-existing-schema
Export into pre-existing schema - Ask TOM

Export into pre-existing schema Hi tom,I have a schema export with expdp with this -expdp user/passwors@test directory=dump_dir dumpfile=user.dmp logfile=user.log schemas=userUser have 100 tables 50 procedures and triggers now I want to import this on dB how to import it if the user already there with tables and proced