Home > SQL, Technical > Modifying existing column name in Oracle

Modifying existing column name in Oracle

July 27, 2012

Syntax: ALTER TABLE TABLE_NAME MODIFY(Column_name datatype …constraints);
Example: ALTER TBALE ORDERS MODIFY( ORDER_CODE NUMBER(10) NOT NULL);

Advertisements
Categories: SQL, Technical
%d bloggers like this: