1,911 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 5 months
seen 51 secs ago

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


Dec
13
answered Does Oracle 10g Express Edition have enough storage?
Dec
10
comment Is it bad idea to create foreign keys on the tables in a different schemas in the same database for big applications?
You can overuse synonyms and further muddy the question of "what does this refer to?". See here for more details on security, performance and best practices stackoverflow.com/a/10042117/851930
Nov
24
comment How to run stored procedure in another database on the same server using a different login?
which database? Sounds like SQL Server...
Nov
15
awarded  Tag Editor
Nov
15
revised distributed-transactions wiki excerpt
added 449 characters in body
Nov
15
wiki created distributed-transactions excerpt
Nov
15
suggested approved 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