Search
Your cart
  • IMG
    {{cart_item.name}}
    {{cart_item.variation_attribute_name}}: {{cart_item.variation_attribute_label}}
    {{cart_item.item_unit}}: {{ setCurrency(cart_item.price)}}
    {{ setCurrency(cart_item.price*cart_item.quantity)}}
    Invalid quantity more than stock
Total :
{{setCurrency(cart.sub_total)}}
Check out

There is no item in the cart. If you want to buy, Please click here.

ALTER TABLE MODIFY Column

Oracle Database Basic Course

Created by :
Database, Oracle
course
Programming, Software and application
1756
2020-12-07 03:13:23

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,
  ...
);
Oracle Trigger
Content Table
course image

Oracle Views Oracle Indexes Oracle Synonyms Oracle Sequences

Oracle Query Problem Oracle Procedure Oracle Function Oracle Cursor Oracle Trigger
Completed