0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
When was Foreign Keys created?
Foreign Keys was created in 1985.
What are the components of oracle database?
DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.
What are some of the functions for the alter table command in Oracle?
Some of the functions for the alter table command in Oracle include renaming columns or rows, adding columns or rows and marking items as being read only.
How do you change the current Oracle schema?
Alter session set current_schema=my_new_schema;
How do you use foreign key in to oracle?
the foreign key referential between two tables.
Oracle Alter a column's varchar length I want to change a varchar30 to a varchar20. can please help me get the syntax for it?
ALTER TABLE table_name MODIFY (column_name VARCHAR2(20));
Have foreign keys null values?
Yes Foreign key can have null value.
What are the basic components of a database?
Tables, Entities, Attributes, Primary Keys, and Foreign Keys
What is difference between alter and modify on oracle?
MODIFY is a clause used within an ALTER statement, such as ALTER TABLE, ALTER INDEX or ALTER MATERIALIZED VIEW, etc. That is, MODIFY isn't a command by itself. For example, you might change the length of a text column in a table with the following: ALTER TABLE employee MODIFY (email_address VARCHAR(132));
How many foreign keys can you have in one table?
one
What are the limitations of keys and taxonomic system?
Mutations in an organisms' DNA alter its physical appearance
What is the difference between alter session and alter system?
Use the ALTER SESSION statement to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database. Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted. Ankit Kapse
