meta user
network profile
| bio | website | |
|---|---|---|
| location | Ottawa.Ontario, Canada | |
| age | 54 | |
| visits | member for | 1 year, 10 months |
| seen | 3 hours ago | |
| stats | profile views | 36 |
Oracle DBA and programmer with 10 years experience maintaining mission-critical applications. Lots of PL/SQL, C# and the usual glue, vbscript, DOS
|
3h |
revised |
where is oracle session timezone set? added 63 characters in body |
|
3h |
awarded | Constituent |
|
3h |
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 |
would that design be good, reasonable, stable or not? How easy would it be to detach any of the projects if they were to go their own way? This requires some architectural choices at the start of the design but is feasible if you think about it now. |
|
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 |
|
Mar 14 |
revised |
Enforce data integrity with a recursive table added 207 characters in body |
|
Mar 14 |
asked | Enforce data integrity with a recursive table |
|
Feb 18 |
comment |
MySQL : Storing business logic in table I've flagged it for followup. |
|
Feb 18 |
comment |
MySQL : Storing business logic in table I would give the same answer here as you received on StackOverflow so closing it is an option. |
|
Feb 18 |
comment |
MySQL : Storing business logic in table cross posted at StackOverflow stackoverflow.com/questions/14937024/… |
|
Feb 5 |
reviewed | Excellent Recovery time effects of AlwaysOn |
|
Feb 5 |
reviewed | Excellent Finding longest matching prefix |
