11 lines
238 B
SQL
11 lines
238 B
SQL
spool /mnpapp/log/script/SM1736_DDL.log;
|
|
|
|
ALTER TABLE MNP_GEST_RICH_REC_VIRT rename column BUSINESS_ID to BUSINESS_ID_RECIPIENT;
|
|
|
|
ALTER TABLE MNP_GEST_RICH_REC_VIRT
|
|
add
|
|
(
|
|
BUSINESS_ID_DONATING VARCHAR2(36) NULL
|
|
);
|
|
|
|
spool off; |