Tagged Questions
0
votes
1answer
107 views
Pitfalls of creating a foreign key constraint on a system table?
I have a number of tables which hold metadata about the tables and packages in the system. This is intended to be a resource for analysts and documentation so it is not used to create data.
One of ...
3
votes
2answers
335 views
Using Multi-table Insert for Parent and Child Table
Is it safe to use Oracle's multi-table insert statement to insert into a (foreign key constrained) parent and child table?
With minimal examples, I've found that it works as long as the parent table ...
2
votes
1answer
88 views
Constructing Circularly Referenced Tables
I'm attempting to construct two tables in Oracle, A and B; each of these tables reference each other. In my script, I have the foreign key constraints 'in-line' of the create table statements. Of ...
1
vote
0answers
84 views
Dealing with Invisible Referencers
Using Oracle database, suppose I have a parent table parent defined in schema A, and a child table child defined in schema B. To achieve this, schema A granted references privilege on parent to schema ...
4
votes
4answers
420 views
How are foreign key indexes helpful?
How are foreign key indexes helpful? What is the criteria for keeping a foreign key index?
5
votes
2answers
705 views
How to retrieve foreign key constraints data
I'm looking for a query allowing to retrieve foreign key infos (each line: referrencing table & field, referrenced table & field) of an entire schema.
I've found this, but does not gives all ...
