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));
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
ALTER TABLE table_name MODIFY (column_name VARCHAR2(20));
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
alter, altar
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.
change, alter, modify
Change, alter, modify.
Alter
Change, alter, modify.
It means to change or modify something
DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.
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.