【Oracle Database】通过拼接sql修改表属性

SQL> select 'alter table ' || table_name || ' enable row movement' ||';'from user_tables;

'ALTERTABLE'||TABLE_NAME||'ENABLEROWMOVEMENT'||';'
---------------------------------------------------------------
alter table ADDRESSES enable row movement;
alter table CARD_DETAILS enable row movement;
alter table CUSTOMERS enable row movement;
alter table INVENTORIES enable row movement;
alter table LOGON enable row movement;
alter table ORDERENTRY_METADATA enable row movement;
alter table ORDERS enable row movement;
alter table ORDER_ITEMS enable row movement;
alter table PRODUCT_DESCRIPTIONS enable row movement;
alter table PRODUCT_INFORMATION enable row movement;
alter table WAREHOUSES enable row movement;

SQL> select table_name,row_movement from user_tables;

Table
Name                                               ROW_MOVE
-------------------------------------------------- --------
ADDRESSES                                          ENABLED
CARD_DETAILS                                       ENABLED
CUSTOMERS                                          ENABLED
INVENTORIES                                        ENABLED
LOGON                                              ENABLED
ORDERENTRY_METADATA                                ENABLED
ORDERS                                             ENABLED
ORDER_ITEMS                                        ENABLED
PRODUCT_DESCRIPTIONS                               ENABLED
PRODUCT_INFORMATION                                ENABLED
WAREHOUSES                                         ENABLED