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;
解决方案 »
- 如果准实时的从sqlsever的表导入数据到oracle对应表中
- 写一个FUNCTION 或者存储过程,关于几张表的查询 有点难度,大家帮忙
- 在ORALCE中怎么限制一个会话所占用的资源??
- VirtualBox安装增强功能包后还是无法实现鼠标拖拽复制文档的功能?
- 存储过程调用问题,请高手指教!!!!!!!!!
- 哪里有oracle8或oracle7的客户端下载啊,急
- 求一条非常复杂的oracle的sql语句,谢谢!
- 不能安装oracle9i,急急急急.......
- UTL_FILE 使用出错
- 编译触发器出错,在线等,急!
- 有没有谁知道oracle软件在哪下载《谢谢各位了》
- 求助:求一函数或语句,判断数字是否连续,连续几个
确认一下。select * from user_objectes;