oracle修改表中的列
declare v_Count1 int := 0;
v_Count2 int := 0;
v_Count3 int := 0;
v_Count4 int := 0;
v_Count5 int := 0;
v_Count6 int := 0;
begin
select count(1) into v_Count1 from user_all_tables where Upper(Table_Name) = Upper('ZJJHMXBZ');
select count(1) into v_Count4 from user_all_tables where Upper(Table_Name) = Upper('ZJJHMXBZBG');
if(v_Count1 > 0 ) then
select count(1) into v_Count2 from user_tab_cols where Upper(Table_name) = Upper('ZJJHMXBZ') and Upper(Column_Name) = Upper('ZJJHMXBZ_SM');
if(v_Count2 > 0 ) then
execute immediate('alter table ZJJHMXBZ modify ZJJHMXBZ_SM varchar2(4000) ');
end if;
select count(1) into v_Count3 from user_tab_cols where Upper(Table_name) = Upper('ZJJHMXBZ') and Upper(Column_Name) = Upper('ATTRIBUTE15');
if(v_Count3 > 0 ) then
execute immediate('alter table ZJJHMXBZ modify ATTRIBUTE15 varchar2(4000) ');
end if;
end if;
if(v_Count4 > 0 ) then
select count(1) into v_Count5 from user_tab_cols where Upper(Table_name) = Upper('ZJJHMXBZBG') and Upper(Column_Name) = Upper('ZJJHMXBZBG_SM');
if(v_Count5 > 0 ) then
execute immediate('alter table ZJJHMXBZBG modify ZJJHMXBZBG_SM varchar2(4000) ');
end if;
select count(1) into v_Count6 from user_tab_cols where Upper(Table_name) = Upper('ZJJHMXBZBG') and Upper(Column_Name) = Upper('ATTRIBUTE15');
if(v_Count6 > 0 ) then
execute immediate('alter table ZJJHMXBZBG modify ATTRIBUTE15 varchar2(4000) ');
end if;
end if;
end;
最新文章
- Unrecognized attribute 'targetFramework'. Note that attribute names are case-sensitive.
- hangfire+bootstrap ace 模板实现后台任务管理平台
- 微软职位内部推荐-Service Engineer II for Azure Cloud Network
- VRP
- 关于#define预处理指令的一个问题
- 配置Synergy（Server : XP, client: Win7）
- json 数字key json 数字作为主键
- Android 开源库
- 虎说：bootstrap源码解读（重置模块）
- CheckBox in ListView
- linux教程之一
- 开启cocos2dx 3.0的Console功能
- 关于sbutils中的sblaunch插件的疑惑
- .NET反射应用
- 一次花费了一两个小时的mysql问题排查
- JavaScript路线
- 【从零开始搭建自己的.NET Core Api框架】（七）授权认证进阶篇
- 第七周博客作业<西北师范大学|李晓婷>
- Java开发微服务为什么一定要选spring cloud?
- base64转换成图片