1,817 reputation
730
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 3 years, 1 month
seen 12 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


Nov
15
revised distributed-transactions wiki excerpt
added 449 characters in body
Nov
15
wiki created distributed-transactions excerpt
Nov
15
suggested suggested edit on distributed-transactions tag wiki excerpt
Nov
7
comment Save a dynamic cursor for reuse?
@MaxVernon I have made the case for two years running. There's money for some things but not for this it seems...
Nov
7
comment Save a dynamic cursor for reuse?
@MaxVernon given that the reporting tool I use is free but crippled it's actually easier to do this in the database
Nov
7
revised Save a dynamic cursor for reuse?
added 125 characters in body
Nov
7
revised Save a dynamic cursor for reuse?
added 341 characters in body
Nov
7
asked Save a dynamic cursor for reuse?
Oct
27
comment Return a fully dynamic table from an Oracle function
@Michael-O the latest release uses Lucene 3.4. see marceloochoa.blogspot.ca/2011/11/…
Oct
26
comment Return a fully dynamic table from an Oracle function
How about embedding the Lucene index in the database.Lucene Domain Index OJVM is still a work in progress but a possible solution that allows you to query with PL/SQL oracle.com/technetwork/database/enterprise-edition/…
Oct
22
revised Strange Oracle ORDER BY
added 682 characters in body
Oct
22
answered Strange Oracle ORDER BY
Oct
4
comment How to fetch file path from a folder through PL/SQL
windows/linux, what version of Oracle?
Sep
25
revised Enforce a constraint problem
added 1141 characters in body
Sep
24
revised Enforce a constraint problem
more explanation
Sep
24
revised Enforce a constraint problem
added for clarity
Sep
24
revised Enforce a constraint problem
fixed an logic error
Sep
24
answered Enforce a constraint problem
Sep
24
answered How to become a DBA…the non-standard route (not beginning as sysadmin or dev)?
Sep
16
asked Enforce a constraint problem