answersLogoWhite

0

the foreign key referential between two tables.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

How do you alter foreign keys in oracle?

To alter foreign keys in Oracle, you can use the ALTER TABLE statement. To modify an existing foreign key constraint, you typically need to drop the existing constraint first using ALTER TABLE table_name DROP CONSTRAINT constraint_name, then add a new foreign key constraint with the desired modifications using ALTER TABLE table_name ADD CONSTRAINT constraint_name FOREIGN KEY (column_name) REFERENCES other_table (other_column). If you only need to disable or enable the constraint without altering it, you can use ALTER TABLE table_name DISABLE CONSTRAINT constraint_name or ENABLE CONSTRAINT.


Why you need primary key and foreign key?

In sql you use primary key more than one column in a table


What are modules of oracle?

Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.


Could a table only have one primary key and only one foreign key?

Yes it could. It would have a primary key for its own use and it could then have a foreign linking it to another table. If it is only linked to one other table, then it would only need one foreign key. It is also possible to have the same foreign key linking to more than one table.


The key foreign policymakers are?

The key foreign policy makers are?


How do you enter a primary key in oracle when information repeats?

1024


Use the word oracle bone in a sentence?

The oracle bone was priceless.


Can a foreign key be null?

yes .a foreign key can have null values


Why do you designate one of the candidate key of relation to be the primary key?

We designate one of the candidate key of a relation to be a primary key because that primary key is use for any foreign key references.


What are the two key methods the governments use to intervene in foreign trade?

war and sanctions.


What an oracle?

"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods. "Oracle" Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.


What is the advantage of an oracle?

The advantage of an oracle is its ability to use the centralized management system.