40 reputation
2
bio website
location London, United Kingdom
age
visits member for 1 year, 7 months
seen Apr 11 at 10:23

Apr
10
accepted Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?
Apr
10
asked Does hard-coding schema names in procedure calls for Oracle jobs have any performance impact?
Oct
16
asked Where can I find a syntax reference for Oracle SQL Developer's “Generate DB Doc” function?
Sep
11
awarded  Scholar
Sep
11
accepted How to I interleave logs from two different Oracle tables?
Sep
11
comment How to I interleave logs from two different Oracle tables?
I don't think it's the column name - I've also tried changing it and it reports the same error, but creates the view nonetheless.
Sep
11
awarded  Student
Sep
11
comment How to I interleave logs from two different Oracle tables?
OK... actually it does let me create the view, despite that error - isn't Oracle wonderful...
Sep
11
comment How to I interleave logs from two different Oracle tables?
Thanks - that works perfectly. However, Oracle (11g-R2, SQL Developer 3.2) won't let me save that as a view, because: "The SQL syntax is valid, however the query is invalid or uses functionality that is not supported. Declarative query support does not currently include UNION, INTERSECT or MINUS"
Sep
11
asked How to I interleave logs from two different Oracle tables?