Richard Thomas

Thanks a lot.

The query is the view "current_failures" in the script.

Cardinality violation from Natural Join

Strange characters and blank lines with text tables in a transaction

Doesn't work with text tables unfortunately, it rejects loading the CSV file because of empty columns: NOT NULL check constraint; SYS_CT_10093 table: T_TABLE column: PASSENGERCONDITION

Thanks a lot, I'll try that.

String truncation in derived view column

Alright thanks. I thought that was allowed in SQL.