Littlefoot questions

Littlefoot answers

• How to count number of non-consecutive values in a column using SQL?
• Listagg Overflow function implementation (Oracle SQL)
• Is there a way get name of a file without its extension through SQL?
• oracle external table with date column and skip header
• Oracle 12c - Ambiguous column in Insert Into Select Query, ORA-00918
• Oracle sql create query to return value only for one 'employee'
• Allow Commit/Rollback in PRAGMA AUTONOMOUS_TRANSACTION
• PL/SQL equivalent of T-SQL set-oriented variable concatenation
• Concurrent users in Oracle APEX
• Invalid file name when importing a DMP file to very different database