William Robertson

William Robertson has asked 1 questions and find answers to 22 problems.

Stats

About

Career Oracle geek

William Robertson questions

Vim syntax highlighting - exclude specific text from a pattern

William Robertson answers

ORA-01719: outer join operator (+) not allowed in operand of OR or IN
How do you make your check constraint case insensitive in SQL?
Listagg Partition instead of Group By
ORA-12545: Connect failed because target host or object does not exist in Mac - SQLPLUS
Oracle IDENTITY column versus PRIMARY KEY
In Oracle, how do I verify the object type used from an object type hierarchy?
sysdate and dbtimezone different in Oracle Database
Oracle SQL - check missing indexes on SQL query
How to output result of SELECT statement which is executed using native dynamic SQL?
Always true conditional aggregate vs count