Delete
Do Record
Setting
Add New Item
Menu List
| Title | Content Type | Order | Action | ||||||
|---|---|---|---|---|---|---|---|---|---|
| {{kb_content.name}} {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| {{kb_content.name}} | {{setValue(content_types, kb_content.content_type)}} | {{kb_content.sort_order}} | Preview Edit Edit Content | ||||||
| No record | |||||||||
Status: published
Programming, Software and application
2020-12-07 03:13:23
ALTER TABLE MODIFY Column
1809
Introduction to Oracle Database Oracle Tables and Data definition Modifying data Oracle Query and Filter Oracle data types Joining tables Oracle Operators Grouping data Constraints
এই কোর্সে যা থাকছে
৩টি বিষয়
৮০টি লাইভ ক্লাস
To change the definition of a column in a table, you use the ALTER TABLE MODIFY column syntax as follows:
ALTER TABLE table_name MODIFY column_name action;
The statement is straightforward. To modify a column of a table, you need to specify the column name, table name, and action that you want to perform.
Oracle allows you to perform many actions but the following are the main ones:
- Modify the column’s visibility
- Allow or not allow null values
- Shorten or widen the size of the column
- Change the default value of a column
- Modify expression of the virtual columns
To modify multiple columns, you use the following syntax:
ALTER TABLE table_name MODIFY ( column_name_1 action, column_name_2 action, ... );