Home
Videos uploaded by user “Connor McDonald”
Hints and Tips - A silent movie on joins
 
02:31
The vision says it all ... a basic primer on how joins are performed in Oracle, using the metaphor of playing cards. Enjoy... ========================================­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2117 Connor McDonald
KISS series on Analytics: 01 Ranking rows
 
03:30
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at how to assign a rank value to rows The sample problem we'll solve is: Show me the sequence in which everyone joined our company using RANK() Scripts: https://livesql.oracle.com/apex/livesql/s/ch1tefsz0mc75pk4ix2jbfja7 Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3637 Connor McDonald
KISS series on Analytics: 03 Mind the gap
 
03:09
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at using our ranking functions to solve problems with gaps in data The sample problem we'll solve is: Discover contiguous ranges of data using analytic functions. Scripts: https://livesql.oracle.com/apex/livesql/s/cljrgh80cczwjtptlpk2e5081 Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2086 Connor McDonald
AskTOM TV - Direct path read
 
04:59
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at direct path reads and how they interact with objects that may already have changed buffers in the buffer cache blog: https://connor-mcdonald.com
Views: 603 Connor McDonald
Oracle 18c - Private temporary tables
 
01:57
New to 18c! Private temporary tables. blog: https://connor-mcdonald.com Not only is your data private to your session, but so is the definition of the table itself.
Views: 1570 Connor McDonald
AskTOM TV - SQL Plan Directives from DBMS_XPLAN
 
06:15
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how to identify which SQL Plan Directivees are being used for a given query blog: https://connor-mcdonald.com ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1032 Connor McDonald
Hints and Tips - Self documenting SQL
 
06:02
Good quality code stands alone, in that its purpose and function can be gleaned from the code itself without supporting documentation. This is not to say supporting commentary is not useful - its more a reflection on the quality that we aspire to get from the code itself. But can we apply that same principle to the SQL we write ? Yes, we can. ====================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3156 Connor McDonald
KISS series on Analytics: 25 The KEEP clause
 
04:05
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at the new KEEP clause to collect extra column when performing aggregates, to avoid the need to do another join back to the source table. Script: https://livesql.oracle.com/apex/livesql/file/content_C85WW581KIH95H1QKH08H8H5G.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 850 Connor McDonald
ROWNUM - so simple yet so much confusion!
 
05:05
ROWNUM just assigns a counter to the rows in your query result. So why did so many people get our simple quiz on rownum wrong ? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 705 Connor McDonald
Hints and Tips - Using NULLIF in SQL
 
01:58
An easy method to avoid divide by zero by using NULLIF ========================================­­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2473 Connor McDonald
KISS series on Analytics: 10 Window clause
 
05:09
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we take our first look at the final clause in our analytic syntax - the WINDOW clause The sample problem we'll solve is: How analytic aggregation returns two types of aggregates - either reporting or windowing aggregates. Scripts: https://livesql.oracle.com/apex/livesql/file/content_CQXSUXL3JBUOBC82NO9SKKGLE.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1406 Connor McDonald
Big news for AskTOM
 
02:26
The next generation of AskTOM is here! Join us for this exciting announcement. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week #dontbefooled
Views: 1242 Connor McDonald
KISS series on Analytics: 07 Partition clause
 
03:20
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we take our first look at the partition clause The sample problem we'll solve is: Applying ranking functions to data when it is logically grouped into sections, in this case, populations of countries by continent Scripts: https://livesql.oracle.com/apex/livesql/file/content_ERYV6B909XK196IAKLBUQIJSN.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1211 Connor McDonald
KISS series on Analytics: 04 More ranking options
 
04:20
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at more esoteric ranking functions with a more statistical background The sample problem we'll solve is: Show me distributions of Hollywood movie box office sales using PERCENT_RANK, CUME_DIST and NTILE (quartile, decile, tertile, etc) Scripts: https://livesql.oracle.com/apex/livesql/s/clq6jmj1jzju4k23v3tnbzo8u Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1759 Connor McDonald
KISS series on Analytics: 05 Dealing with null
 
04:14
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at using our ranking functions when nulls are present. Scripts: https://livesql.oracle.com/apex/livesql/s/cokpdete3hiy3jo0yzoa4eerz Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1401 Connor McDonald
A peek at bind variable peeking
 
08:27
The evolution of adaptive cursor sharing, starting with the need for the optimizer to be able to look (peek) at the value of a bind variable in order to determine the best execution plan. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week Music: Night Owl (Broke For Free) #oracle #performance
Views: 444 Connor McDonald
Where is my tracefile
 
04:32
SQL trace is an awesome performance tuning resource. But before you can do that analysis, you need to know WHERE your trace file is. ========================================­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3006 Connor McDonald
My laptop can't fly.... but 18cXE does!
 
03:24
Out with the old laptop, and in with a new desktop machine at home. There's no better time to test out the upcoming 18c XE database release with Application Express! blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Download 18c database: https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Download Application Express: https://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html Subscribe for new tech videos every week https://www.youtube.com/c/connormcdonaldoracle?sub_confirmation=1 =========== Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle
Views: 2341 Connor McDonald
Oracle 12c Release 2 - How to do transparent data encryption ONLINE
 
01:32
Your data should be encrypted to keep it secure...Now you can do the encryption process without taking your applications away from your users. ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1312 Connor McDonald
Hints and Tips - Synthesizing rows inside Oracle
 
06:55
You've already got a gazillion rows inside your Oracle Database table. So why would you want to generate even more rows ? Well, it’s a common need as you'll see in this quick tip, which more to the point shows you how to do it easily and efficiently with SQL ====================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2039 Connor McDonald
KISS series on Analytics: 21 Grouping ranges of data
 
03:59
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we revisit the classical problem of identifying ranges of data within a set. Script: https://livesql.oracle.com/apex/livesql/file/content_C35KKE5TX8H1O3M2Z5TLAGAON.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 784 Connor McDonald
Online EVERYTHING in 12c Release 2 and 18c
 
04:29
If you're a DBA, you'll love that you can do just so much stuff in the database in 12c Release 2 and above that does NOT need an outage. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 1065 Connor McDonald
Peeking on steroids: Adaptive Cursor Sharing
 
06:24
blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Bind peeking in early version of Oracle: https://youtu.be/MnISfllmK74 Issues with bind peeking: https://www.youtube.com/watch?v=ynLF6S15J5M Subscribe for new tech videos every week All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Music: Night Owl (Broke For Free) #oracle #binds #performance
Views: 391 Connor McDonald
Hints and Tips - DML error logging - make your SQL loads more productive
 
06:15
There is nothing worse than spending hours trying to load data into a table, only to have that load fail and you end up with nothing to show for your efforts. DML error logging will solve that problem for you. This quick tip shows you how easy it is ====================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 2409 Connor McDonald
18c XE will blow your mind
 
03:38
Highlights from the June DBA Office Hours session. blog: https://connor-mcdonald.com - Subscribe as new tech videos come every week!
Views: 2986 Connor McDonald
How to detect data changes and notify applications of those changes
 
09:39
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 867 Connor McDonald
Hints and Tips - Queries running whilst exchanging partitions - part 1
 
01:44
Even when you rip out a partition from a table, queries can still execute successfully. ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 958 Connor McDonald
Quick Tip - Better Truncate in 12c
 
03:41
blog: https://connor-mcdonald.com Many of the limitations of TRUNCATE command are lifted in Oracle Database 12c ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 818 Connor McDonald
Large updates with minimal outages and minimal redo?
 
04:34
Got a massive set of rows to change? Worried about the performance, the redo cost, and the huge outage? Maybe there is a better way! blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 585 Connor McDonald
KISS series on Analytics: 28 Partitioned outer join
 
03:34
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. We are now looking at functions that are not specifically analytics, but they are present in the Data Warehousing Guide in the SQL for Analysis chapter. In this session we look at the partitioned outer join feature - the ability to do an outer join on logical groupings of the data. Script: https://livesql.oracle.com/apex/livesql/file/content_DDWIGFEMAI346G037QIRDJS8D.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 709 Connor McDonald
AskTOM TV - How statistics and in-database archiving (row archival) co-exist
 
07:17
blog: https://connor-mcdonald.com A video to help you understand the "thought process" behind answering AskTom questions. In this episode, how does the optimizer deal with the 12c in-database archiving feature ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 544 Connor McDonald
How can I speed up a query if an index cannot help?
 
08:20
blog: connor-mcdonald.com Highlights from the April DBA Office Hours session. Office Hours is 100% free Q&A sessions held every month by Oracle experts to help you succeed with the Oracle suite of technologies. Music: Smells Like Summer - Del (Vlog Music No Copyrighted) Video Link: https://youtu.be/IrkMsqcOjGU
Views: 1445 Connor McDonald
KISS series on Analytics: 14 NTH_VALUE in windows
 
04:36
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at how the nth_value function can be used to explore different boundary values within a window The sample problem we'll solve is: Compare current data with the 2nd lowest and 2nd highest values within our window. Scripts: https://livesql.oracle.com/apex/livesql/file/content_CVLPCO2ZHLLF15JGHXMCJ0FIL.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 875 Connor McDonald
Oracle 18c - Before you upgrade, check utl_file_dir
 
01:57
blog: https://connor-mcdonald.com 18c no longer supports utl_file_dir. Check your code before upgrading!
Views: 692 Connor McDonald
KISS series on Analytics: 16 Dynamically changing window ranges
 
04:33
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at how the window ranges can be dynamic based on the actual table data. The sample problem we'll solve is: We'll use a PLSQL function to dynamically set the number of days to look back from the current row, based on the day of the week Scripts: https://livesql.oracle.com/apex/livesql/file/content_CYAE37SZBU2770BVYW2OT1Q4I.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 786 Connor McDonald
KISS series on Analytics: 27  PIVOT and UNPIVOT
 
05:30
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. We are now looking at functions that are not specifically analytics, but they are present in the Data Warehousing Guide in the SQL for Analysi s chapter. In this session we look at how to transpose rows to columns, and columns to rows, using PIVOT and UNPIVOT. Script: https://livesql.oracle.com/apex/livesql/file/content_DCC032IJONO8467JXDM2X9I7T.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 698 Connor McDonald
Faster Inserts!
 
05:06
Lots of tools generate insert scripts from existing data. But here's a trick to make those inserts run MUCH faster. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d All other social media channels here: https://linktr.ee/connor My current favorite Oracle stuff: - Favorite 12.2 feature: Almost all structural maintenance can be done online. No more outages. https://docs.oracle.com/en/database/oracle/oracle-database/12.2/newft/new-features.html#GUID-BEEEA34D-3D81-4360-887C-A92BC711816D - Favorite 18c feature: Killing a runaway SQL without killing the entire session. https://docs.oracle.com/en/database/oracle/oracle-database/18/newft/new-features.html#GUID-49F77A8D-CF54-415C-B04F-DB4CE733C513 - Favorite 19c feature: Handling JSON just got a lot easier! https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-9587F5B4-871B-401A-8978-BDA491F07F8A Subscribe for new tech videos every week Music: Night Owl (Broke For Free) #oracle #insert #performance
Views: 384 Connor McDonald
AskTOM TV - SQL trace, SQL plus, SQL developer
 
05:12
A video to help you understand the "thought process" behind answering AskTom questions. In this episode, we look at how we can use SQL trace to diagnose what autotrace privileges we need in SQL Developer blog: https://connor-mcdonald.com ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1468 Connor McDonald
Chained rows? Migrated rows?
 
10:37
Understanding the basics of what happens when rows are just too damn big. blog: https://connor-mcdonald.com Highlights from the June DBA Office Hours session. Subscribe as new tech videos come every week!
Views: 705 Connor McDonald
Getting to the core of things... or is it socket? or cpu?
 
02:36
blog: https://connor-mcdonald.com A TL;DR version of the discussion on cores, CPUs and sockets from the recent AskTOM Office Hours session. Subscribe for regular videos on Oracle technology! music: bensound.com
Views: 464 Connor McDonald
Create your 18c database with a few clicks!
 
02:22
Oracle 18c Database is downloadable for everyone, and you can get your first database up and running with just a few clicks (and perhaps a cup of coffee!) blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week music: incomptech.com
Views: 4836 Connor McDonald
KISS series on Analytics: 19 Removing the duplicates
 
03:45
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we look at the classical problem of removing duplicates from unclean data. Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1014 Connor McDonald
ONLINE table maintenance WITHOUT upgrading to 12c Release 2
 
03:33
Online table maintenance is trivial in the current versions. But what about those of us that are still stuck on the older versions? Can I avoid lengthy downtime when changing table structures ? blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe as new tech videos come every week!
Views: 448 Connor McDonald
I've got some good news... and some bad news
 
03:03
All the news on 18c from this months DBA Office Hours session. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week
Views: 882 Connor McDonald
18c Merge Partitions Online
 
06:24
blog: https://connor-mcdonald.com Having trouble merging ? 18c has got you covered.
Views: 413 Connor McDonald
Hints and Tips - Avoiding never ending locks - part 1
 
05:52
Row locking is a critical component of ensuring the integrity of your data inside the database. But locks of extended duration can easily create system-wide problems in your applications. This quick tip gives you some ideas for handling locks better. ====================================================== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1299 Connor McDonald
KISS series on Analytics: 12 The RANGE option in WINDOWS
 
04:40
Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, use the RANGE option within the WINDOW clause to perform a moving average Scripts: https://livesql.oracle.com/apex/livesql/file/content_CR93UBGK2U7OAW6K1EHTBBYHD.html Watch the entire Analytics playlist at https://www.youtube.com/playlist?list=PLJMaoEWvHwFJDyhMLCkNSSUQWw9waFkIj ========================================­­­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1031 Connor McDonald
Hints and Tips - SQL*Plus tricks
 
06:07
It's been around forever... but that does not make it obsolete. Here's how you can get the most out of SQL*Plus ========================================­­============== Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3502 Connor McDonald
Analytics: 10 Window clause
 
05:20
blog: https://connor-mcdonald.com Welcome to the KISS video series. Solving problems that typically required complicated SQL in the past, that can now be easily solved with Analytic SQL syntax. In this session, we take our first look at the final clause in our analytic syntax - the WINDOW clause The sample problem we'll solve is: How analytic aggregation returns two types of aggregates - either reporting or windowing aggregates. Scripts: https://livesql.oracle.com/apex/livesql/file/content_CQXSUXL3JBUOBC82NO9SKKGLE.html
Views: 720 Connor McDonald
AskTOM TV - how to read the HIGH_VALUE and other LONG columns
 
07:46
blog: https://connor-mcdonald.com A short video to help you understand the "thought process" behind answering AskTom questions. In this episode, how do we interrogate the HIGH_VALUE column in USER_TAB_PARTITIONS so we can see the correct boundary information for partitions ========================================­­­­============== Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 1248 Connor McDonald