HomeХобби и стильRelated VideosMore From: Biz Tech Talk

SQL How-to NVL, NVL2 KEEP DENSE RANK

1 ratings | 120 views
A video on using the switching functions NVL and NVL2 to handle null values in SQL and how to create a binary flag. Also the use of Keep dense rank to return a value from the first or last row in a rank argument. Part of the SQL How-To Series A short video on how you can import Excel data into an Oracle database using AllAround Automations PLSQL Developer Jump to NVL 5:16 -- Click on the time to jump NVL2 9:17 -- Click on the time to jump Keep dense rank 13:02 *You will need to watch the rest of the video for this* Thanks to AllAround: www.allroundautomations.com Check out my site for Associated Blog: http://scottstansfield.com/ Follow me on Twitter: twitter.com/biztechscott
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.