Recent content by layco

You are able to declare environmental variables to be contained within a package. That is you can assign a value to a variable that is held by the package and reference it later from another procedure in the same package. You can constrict certain object naming to the package so that if you...

I have been struggling a bit with the reports. Our product has been developed over the last several years without a DBA to guide the database design. We have no foreign keys and very few primary keys actually designated in the database. My job is to divine and implement these relationships and...

You're right I can get what I need from a PDM. I'll go back and work from there. I'm feeling frustrated because I want to master this tool and I keep stumbling around. I'd like to have a manual I can just sit down and read cover to cover. For instance, I spent yesterday afternoon trying to...

I am an Oracle DBA with several years experience. I am using PowerDesigner to develop a conceptual model for a database I've reverse engineered. I find some of the terms confusing and of course, because I'm working backwards(-:, I am stumbling around a bit. One question I've got is what tables...

If your application is going to go into database replication you will need to use a guid (globally unique identifier) instead of a sequence for your primary key. This will allow replication of your table to databases at other locations. In general I think replication is pretty much inevitable...

Oracle has always been very liberal in distributing it's software. All the downloads and CD distributions contain full versions. The only difference is a splash screen. The license states 30 days but there are no bombs and I've used old versions for years. This makes good since from Oracle's...

It sounds like you need to normalize your problem and use two tables, incident and unit.