create or replace procedure hello(w_gg out number) is W_DENPYONO NUMBER(10);
begin W_DENPYONO :=10;
CREATE GLOBAL TEMPORARY table aaab as (select * from emp)end hello;在存储过程中执行CREATE GLOBAL TEMPORARY table aaa as (select * from emp)会报错
如何执行才是对的?
谢谢!
begin W_DENPYONO :=10;
CREATE GLOBAL TEMPORARY table aaab as (select * from emp)end hello;在存储过程中执行CREATE GLOBAL TEMPORARY table aaa as (select * from emp)会报错
如何执行才是对的?
谢谢!
begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << close current delete fetch lock insert
open rollback savepoint set sql execute commit forall merge
<a single-quoted SQL string> pipe
<an alternatively-quoted SQL string>
求助!