Custom Search
www.rocket99.com : Technical Guides
Sybase
Oracle
UNIX
Javascript
Technical Guides
Sybase
Oracle
UNIX
Javascript
Of Interest
Business Intelligence and Analytics
Oracle Training
Oracle » DDL » Design »
Changing a column's type or name
-- Change Type
ALTER TABLE CORPORATION MODIFY (COMPANY_NM VARCHAR2(100));
alter table employee modify ( last_name varchar2(40) );
-- Change Name
alter table employee rename column last_name to last_nm ;
Oracle : Related Topics
Oracle : DDL : Creating a table
Oracle : DDL : Creating indexes
Oracle : DDL : Creating constraints
Oracle : DDL : Creating and using a sequence
Oracle : DDL : Synonyms and Database Links
Oracle : DDL : Partitioned Tables
Oracle : DDL : Alter a column
Oracle : DDL : Creating an index with the nosort option
Oracle : DDL : Oracle data types
Sybase Web Site
Sybase Mobile Web Site
Oracle Web Site
Get the latest Rocket99 news and tech tips via
Site Index
About this Guide to Sybase, Oracle, and UNIX
Contact Us
Advertise on this site
Copyright © 2012
Stoltenbar Inc
All Rights Reserved.