1,897 reputation
732
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 4 months
seen 7 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


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
Aug
16
awarded  Popular Question
Jul
26
awarded  Popular Question
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