kevinsky

1,548 reputation

422

bio	website
	location	Ottawa.Ontario, Canada
	age	54
visits	member for	1 year, 10 months
	seen	10 hours ago
stats	profile views	36

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

	1,548 reputation	bio	website		visits	member for	1 year, 10 months
422 badges		location	Ottawa.Ontario, Canada		seen	10 hours ago

summary answers questions tags badges favorites bounties reputation activity

55 Comments

suggestions reviews revisions comments badges posts accepts all

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	would that design be good, reasonable, stable or not? How easy would it be to detach any of the projects if they were to go their own way? This requires some architectural choices at the start of the design but is feasible if you think about it now.
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.
Feb 18	comment	MySQL : Storing business logic in table I've flagged it for followup.
Feb 18	comment	MySQL : Storing business logic in table I would give the same answer here as you received on StackOverflow so closing it is an option.
Feb 18	comment	MySQL : Storing business logic in table cross posted at StackOverflow stackoverflow.com/questions/14937024/…
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!
Oct 25	comment	oracle how to call procedure better yet ask another question about migrations
Oct 25	comment	Data archival strategy that handles schema changes? "a substantial schema change every quarter" Yikes! Could indicate that the existing schema is badly designed. I grant it's not relevant to your question though.
Oct 15	comment	Why an object became invalid in oracle databse. changing the parameters in procedures and functions in packages or just recompiling stand alone procedures will do it to.