Oracle alter table modify column Syntax example
http://www.dba-oracle.com/t_alter_table_modify_column_syntax_example.htm
For complete tips on Oracle alter table syntax, see the book "Easy Oracle Jumpstart". Oracle provides "alter table" syntax to modify data columns in-place in this form:
alter table
table_name
modify
column_name datatype;
If you are brave you can use a single "alter table" syntax to modify multiple columns:
alter table
table_name
modify
(
column1_name column1_datatype,
column2_name column2_datatype,
column3_name column3_datatype,
column4_name column4_datatype
);
Here are some examples of Oracle "alter table" syntax to modify data columns and note that you can add constraints like NOT NULL:
ALTER TABLE
customer
MODIFY
(
cust_name varchar2(100) not null,
cust_hair_color varchar2(20)
)
;
We can also use Oracle "alter table" syntax in dynamic PL/SQL to modify data columns
BEGINSQL_STRING := 'ALTER TABLE '||:TABLE_NAME||' MODIFY '||:COLUMN_NAME||' VARCHAR2(100)'; . . .
END;
最新文章
- C#通过NPOI操作Excel
- 深入浅出Struts2+Spring+Hibernate框架
- 【安装mysql】windows安装压缩版mysql5.7.15
- 【Eclipse】修改 编码格式
- #添加图片,最多只能上传9张.md
- 448. Find All Numbers Disappeared in an Array Add to List
- JSP的九个隐式(内置)对象
- hadoop学习记录(三)HBase基本概念
- HDU 3943 K-th Nya Number(数位DP)
- JavaScript的闭包特性
- SVN中Branch的创建于合并
- codeforces#1132 F. Clear the String(神奇的区间dp)
- Python从入坑到放弃!
- CF603E Pastoral Oddities
- Linux下rsyslog日志收集服务环境部署记录【转】
- Java运算符号,对象赋值,别名
- 在Windows上安装Gradle
- 解密微信sqlite数据库
- PyCharm2017破解版安装
- pyCharm最新2019激活码