declare
tablenames varchar2(2000);
var_sql varchar2(2000); --------200好像不够
Cursor tablename_cursor is
select t.table_name from user_tab_comments t where t.table_name like 'EXIT2012%';
begin
open tablename_cursor;
loop
fetch tablename_cursor into tablenames;
exit when tablename_cursor%notfound;
if tablename_cursor%found then
var_sql:='create table dataanalysis2012.'||tablenames||' as select vehiclelicenseAuto,vehiclelicense,EntryStation,ExitStation,EntryTime,ExitTime,VehicleType,VehicleClass,TotalWeight from DBBASE2012.'||tablenames;
execute immediate var_sql;
end if;
end loop;
close tablename_cursor;
end;
tablenames varchar2(2000);
var_sql varchar2(2000); --------200好像不够
Cursor tablename_cursor is
select t.table_name from user_tab_comments t where t.table_name like 'EXIT2012%';
begin
open tablename_cursor;
loop
fetch tablename_cursor into tablenames;
exit when tablename_cursor%notfound;
if tablename_cursor%found then
var_sql:='create table dataanalysis2012.'||tablenames||' as select vehiclelicenseAuto,vehiclelicense,EntryStation,ExitStation,EntryTime,ExitTime,VehicleType,VehicleClass,TotalWeight from DBBASE2012.'||tablenames;
execute immediate var_sql;
end if;
end loop;
close tablename_cursor;
end;
解决方案 »
- oracle 存储过程的问题,高分期待高手!!!!!!1
- 一个oracle建表问题
- sqlcode=4098 请问是什么 sqlcode一般怎么查错误信息啊
- oracle 两张表,根据其一张表的标记,来决定这张表的某个字段取第二张表的值 查询如何实现
- 数据库事务 锁和并发问题请教...
- 在windows中和linux系统在oracle中使用datediff的问题
- oracle实现sqlserver isdate函数方法
- oracle有没有复制一行数据并插入另一张表的语句
- 在java中调用oracle数据库中的存储过程
- select * from a where (rowid,oid,name,rundate) in (('...',2,'nn',null),(null,2...))类似这样的句子应该怎么写?主要是null值得应用
- 有没有谁知道oracle软件在哪下载《谢谢各位了》
- 求助:求一函数或语句,判断数字是否连续,连续几个
确认一下。select * from user_objectes;