answersLogoWhite

0

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));

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

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


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));


What is the basic difference between oracle 10g and 11i?

11i features is index rebuild eg: alter index index_name rebuiled and @db_link by using dblink we can access the data from multiple servers


What is a homophone for the word modify?

alter, altar


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.


What is the synonym of convert?

change, alter, modify


What are synonyms of affect?

Change, alter, modify.


What is a homophone and synonym for change and modify?

Alter


What are three synonyms for increase?

Change, alter, modify.


When you alter something what does it do?

It means to change or modify something


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.