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

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


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
5
reviewed Excellent Recovery time effects of Availability Groups
Feb
5
reviewed Excellent Finding longest matching prefix
Feb
5
reviewed Satisfactory Simplify and optimize a complex query
Feb
5
awarded  Custodian
Feb
5
reviewed Satisfactory Is there a way to speed up an ALTER statement in SQL Server
Jan
11
comment Database can be accessed by all
I am a little bit uneasy about the idea of installing a production database on a non server operating system that will no longer be supported by Microsoft soon and using wireless for transmitting the data. There are just so many ways this can go wrong.
Jan
10
awarded  Custodian
Dec
18
comment Read ancient Oracle database into current Oracle version
I believe you can still download 9i which is not too far from 8. If this is worth the time you could install 9i on a test box and see if the files are recognized.
Dec
5
revised Periodic Oracle restarts…intentionally
clarification
Nov
29
comment Software tool to visualize and print DB diagrams
I like the data modeler from Oracle. It's not Erwin but it can do a lot of what you need
Nov
25
comment Force number precision in a view with Union
good answer, using CAST on the overall select works fine and gives a view with the column precision of NUMBER(1).
Nov
25
accepted Force number precision in a view with Union
Nov
25
comment Oracle Enterprise Manager font problem, some text is displayed in Chinese and with squares
was it always like this or is this a new install?
Nov
23
comment Force number precision in a view with Union
I am away from my desk but that looks interesting. What is the precision when you run it?
Nov
23
revised Force number precision in a view with Union
added 421 characters in body
Nov
23
comment Force number precision in a view with Union
Sorry Phil, the desired result is NUMBER(1)
Nov
23
revised Force number precision in a view with Union
added 182 characters in body
Nov
23
asked Force number precision in a view with Union