我在oracle中创建了一个私有临时表,下面是
create private temporary table ora$ptt_users as
select * from lul_users;
这个工作正常,但是当我添加一个提交保存定义,如下所示
create private temporary table ora$ptt_users as
select * from lul_users on commit preserve definition;
我得到一个"SQL命令没有正确结束。任何建议
你把子句放错地方了:
create private temporary table ora$ptt_users
on commit preserve definition as
select * from lul_users;
fiddle (againstdual
).
请参阅文档,包括全局临时表的示例