1,817 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years
seen 43 mins ago

Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS


Jul
16
awarded  Yearling
Jul
12
comment linked list in SQL and Trees
@ypercube Excuse me! It's all about terms. I should have said a tree structure rather than a linked list.
Jul
12
comment linked list in SQL and Trees
I am currently working on a client report using a linked list. Their question was: Given a grandparent, show all the grandchildren. The SQL is just ugly. The reverse question equally so.
Jul
12
comment linked list in SQL and Trees
I have to work with a linked list type structure in a database and it prompted this question dba.stackexchange.com/questions/36698/… It can be done in a database but it can be difficult to marry the functionality of a linked list with database constraints which enforce integrity
Jun
6
comment Proper Use of Lookup Tables
In my shop the thinkers were able to stop after only four choices, male, female, transgender, would not disclose.
Jun
6
comment Insert into table from a query to a linked database hangs
I would create a view encapsulating your query on the origin database and then query the view. That way you force the join and trimming to be done on the origin database
May
29
accepted where is oracle session timezone set?
May
29
answered where is oracle session timezone set?
May
23
revised where is oracle session timezone set?
added 63 characters in body
May
23
awarded  Constituent
May
23
asked where is oracle session timezone set?
May
13
awarded  Caucus
Apr
16
awarded  Popular Question
Mar
19
comment Enforce data integrity with a recursive table
I'm not able to implement all of your solution as it requires changing existing constraints but I can adapt your solution to solve the problem. Thanks!
Mar
19
accepted Enforce data integrity with a recursive table
Mar
15
comment Enforce data integrity with a recursive table
This looks very interesting! I will try it out Monday and report back to see if this answers the question.
Mar
15
comment Database Design question, calculate or save financial positions
I reread your question. You can store the tax amounts as long as you also store a reference to which tax rate was used. Rates go up and down and you need to show the accountants which transactions used which rates.
Mar
14
revised Enforce data integrity with a recursive table
added 283 characters in body
Mar
14
revised Enforce data integrity with a recursive table
added sample data
Mar
14
revised Enforce data integrity with a recursive table
added 91 characters in body