1,765 reputation
627
bio website
location Ottawa.Ontario, Canada
age 55
visits member for 2 years, 9 months
seen Apr 1 at 18:18

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
4
comment How to fetch file path from a folder through PL/SQL
windows/linux, what version of Oracle?
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
Mar
19
comment Enforce data integrity with a recursive table
I'm not able to implement all of your solution as it requires changing existing constraints but I can adapt your solution to solve the problem. Thanks!
Mar
15
comment Enforce data integrity with a recursive table
This looks very interesting! I will try it out Monday and report back to see if this answers the question.
Mar
15
comment Database Design question, calculate or save financial positions
I reread your question. You can store the tax amounts as long as you also store a reference to which tax rate was used. Rates go up and down and you need to show the accountants which transactions used which rates.
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.
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.
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
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
comment Force number precision in a view with Union
Sorry Phil, the desired result is NUMBER(1)
Nov
5
comment Pitfalls of creating a foreign key constraint on a system table?
@Phil please submit your comment as an answer and I'll do so
Oct
25
comment Oracle Enterprise Manager 11g dbconsole “Internet Explorer cannot display the webpage”
Is it possible that the required apex tables or users have removed or have locked accounts
Oct
25
comment oracle how to call procedure
Create new schema, import the data into that schema using the old export/import or the datapump which I think will work from self to self. Then, in the new schema, redefine your fields and do the ORM from there. But if you continue to work with the original schema you will have pain later. Best way is to redefine the original schema but this must be tested!