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));
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
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?
A homophone for the word "modify" is "mollify".
What are synonyms of affect?
Change, alter, modify.
What is a homophone and synonym for change and modify?
Alter
What is the synonym of convert?
change, alter, modify
When you alter something what does it do?
It means to change or modify something
What are three synonyms for increase?
Change, alter, modify.
What are the components of oracle database?
DDL - Data Definition Language Create,Alter,Drop and Truncate are the components of oracle database.
What is a synonym word for adjust?
Alter or modify are but two of many.
What is a meaning of amend?
change, adjust, alter, modify or revise
