63 reputation
4
bio website
location London, United Kingdom
age
visits member for 1 year, 10 months
seen Jul 8 at 10:05

May
31
accepted What is the advantage of using numeric primary keys in a relational database?
May
31
comment What is the advantage of using numeric primary keys in a relational database?
Thanks @mdoyle - great answer. I recently had to design a table for storing XML schemas, and I keyed it by namespace. Clearly, if that table gets big then the size PK index could become an issue, but at the moment there are five entries and I couldn't justify adding a surrogate key, as you call it. I guess XML namespace is an example of a "natural" key, but my trivial "widget" example doesn't have a natural key.
May
31
awarded  Supporter
May
31
asked What is the advantage of using numeric primary keys in a relational database?
May
2
accepted How can I limit a hierarchical query to the point where there are multiple children?
May
2
comment How can I limit a hierarchical query to the point where there are multiple children?
I had to qualify the select * as select hier.*, but other than that your query is great - thanks again!
May
2
answered How can I limit a hierarchical query to the point where there are multiple children?
May
2
asked How can I limit a hierarchical query to the point where there are multiple children?
May
2
accepted How can I select rows from a hierarchical query with the lowest level?
May
2
comment How can I select rows from a hierarchical query with the lowest level?
Thanks - you're absolutely correct. I didn't have "the_level" in the cte query so it was failing otherwise.
May
2
awarded  Editor
May
2
revised How can I select rows from a hierarchical query with the lowest level?
Thanks for that! I got a connect by error because of the "level" in the final query. In the past I've found that giving "level" an alias solves this, as per my amendment - does that make sense?
May
2
suggested suggested edit on How can I select rows from a hierarchical query with the lowest level?
May
2
comment How can I select rows from a hierarchical query with the lowest level?
@ypercube Yes, it does.
May
2
asked How can I select rows from a hierarchical query with the lowest level?
May
2
asked How can I select rows from a hierarchical query with the lowest level?
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