以下语句执行总是不成功,大家帮忙看看问题在哪里,应该如何修改(只能在语句块中执行,不能建立存储过程、包等)
DECLARE
ictTb number(10):=0;
begin
select count(1) into ictTb from dba_tables where TABLE_NAME = 'XX' and OWNER = 'DATAEXP';
if ictTb > 0 then
drop table DATAEXP.XX;
end if;
create table DATAEXP.XX as select * from DATAEXP.TBL_XX;
end;
---------------------------------------------------------------------------------------
环境:
server:oracle 11g(linux)
client:winxp、oracle sql Developey
DECLARE
ictTb number(10):=0;
begin
select count(1) into ictTb from dba_tables where TABLE_NAME = 'XX' and OWNER = 'DATAEXP';
if ictTb > 0 then
drop table DATAEXP.XX;
end if;
create table DATAEXP.XX as select * from DATAEXP.TBL_XX;
end;
---------------------------------------------------------------------------------------
环境:
server:oracle 11g(linux)
client:winxp、oracle sql Developey
解决方案 »
- 关于clob作为输入参数传到存储过程的求助
- crontab调用rman报错!!!!!!在线等待!!!!!急
- 也是多行数据拼接到一行,没法用存储过程。求各位帮助!
- 基础,导出导入表,麻烦解疑下
- sleect count(*) 慢!!!!!!!!!!!!
- 如何把某字段值中/去掉
- 请问怎么在Where语句中使用字段别名?
- Oracle的远程连接数据库的连接字符串怎么写?
- 能不能改变已经安装的数据库的字符集??
- win2008安装oracle11g数据库后,网络连接一直转圈,如图。
- SQL语句中如何实现第i行与第j行记录合成1行记录,第i+1与j+1合成第2行记录...
- oracle9i dedicated server->mts模式?
换成
execute immediate 'create table DATAEXP.XX as select * from DATAEXP.TBL_XX';
而直接写成drop table DATAEXP.XX; 和create table DATAEXP.XX as select * from DATAEXP.TBL_XX;却不能执行呢?