Kevin Burton questions

Kevin Burton answers

• In what situations would Rank and Dense Rank be useful?
• pl/sql - compare record counts across 2 user's tables
• How to append text to an oracle clob
• Need an Oracle hierarchical query that returns only full trees for records where children match a search string
• Convert one column by regex into two columns on Oracle 11.1g
• Running node js selenium test case on Chrome get Error Error: ECONNREFUSED connect ECONNREFUSED 127.0.0.1:63528
• analyze query mysql
• Oracle SQL*loader running in direct mode is much slower than conventional path load
• Windows integrated (NTLM) authentication vs Windows integrated (Kerberos)
• What is a temporary CLOB in buffer cache for?