Tag Info

New answers tagged


A cursor is essentially a materialized result set from a query that maintains its own state (essentially remembers what row is "current") and in some cases allows you to manipulate the current row. Cursor lifecycle looks more or less like this: Open the cursor. At this point the query that defines the cursor is executed. Position the cursor. After the ...


You're going beyond the scope of referential constraints with this (good) question. What you are looking for is more to do with Ontologies and Archetypes than RDBMS constraints. You could also check out this page which is on "Intelligent Databases" and gives as an example, medical records. Check out the OpenEHR (Open Electronic Health Record here) whereby ...

Top 50 recent answers are included