select TABLE_NAME from all_tables where table_name like 'AAAAA';
BEGIN
if SQL%notfound then
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
ELSE
execute immediate 'drop table AAAAA';
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
END;或是这样,也不行啊
BEGIN
if SQL%notfound then
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
ELSE
execute immediate 'drop table AAAAA';
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
END;或是这样,也不行啊
begin
select TABLE_NAME into v_table_name from all_tables where table_name ='AAAAA';
if v_table_name=null then
begin
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
end;
else
begin
execute immediate 'drop table AAAAA';
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
end;end;
begin
select count(table_name) into TableCount from all_tables where table_name like 'AAAAA';
if TableCount > 0 then
execute immediate 'drop table AAAAA';
end if;
execute immediate 'create table AAAAA
(
bbb number,
ccc number,
ddd number
)
';
end;唉,,自已结了吧,
原来这样是可以的
,还是要说声谢谢
是应该转到一个表空间下边?
如果在SQL-SERVER 里面是自增ID的列,也就是种子列,就是每次进一条记录时,其ID都会加1如果对照到ORACLE里,应该怎么处理~(不用ROWID)因为那个种子中间有可能是断着的~
START WITH 1 ---其始数值
MAXVALUE 999999999999999999999999999 ---最大值
MINVALUE 0调用是用sequece_name.nextval就可以了
是创建一个 SEQUENCE 就对应到一张表上吗?