1,897 reputation
731
bio website
location Ottawa.Ontario, Canada
age 56
visits member for 3 years, 3 months
seen 2 days 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
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
May
29
accepted where is oracle session timezone set?