怎么样在ORACEL函数中建临时表
解决方案 »
- sql 中 判断是够为空 is null是对的,用=null可以吗
- 按照官方文档装 一路正常。启动sql*plus确出错(ORA-01034: ORACLE not available)
- 根据一组数据修改多 TABLE 的问题
- 解释这句sql意思(简单)
- 请问在Oracle中察看表空间已经使用了总空间的百分之多少的sql语句是什么?
- SQL> sqlldr userid=system/manager@ mingal control=input.ctl这错在哪?
- Oracle 新手疑问3:
- 请问如何判断一个查询结果中两条记录哪个更新?
- 关天developer 2000
- oracle 无效数据对象
- 请教一下分组分页查询问题
- 函数里面创建临时表报错问题,请各们大侠们帮小妹看看,谢谢!
(
ID NUMBER,
VALUE1 NUMBER
)insert into sss values(1,2);CREATE OR REPLACE PROCEDURE BBBB(PO_RESULT OUT SYS_REFCURSOR) IS
BEGIN
execute immediate 'CREATE GLOBAL TEMPORARY TABLE AAA (NUM VARCHAR2(10),QTY INTEGER) ON COMMIT DELETE ROWS '; execute immediate 'insert into AAA SELECT * FROM sss'; OPEN PO_RESULT FOR 'select * from AAA';
END BBBB;
(
tid varchar2(6),
tname varchar2(20)
)
create table SSS
(
ID NUMBER,
VALUE1 NUMBER
)insert into sss values(1,2);
/
create or replace type tabCtest is table of cTest/
create or replace function myTest return tabctest
is execute immediate 'CREATE GLOBAL TEMPORARY TABLE AAA (NUM VARCHAR2(10),QTY INTEGER) ON COMMIT DELETE ROWS '; execute immediate 'insert into AAA SELECT * FROM sss';
Result tabctest := tabctest();
begin
Result := tabctest();
Result.extend;
Result(Result.count) := CTEST(NULL,NULL);
Result(Result.count).tid := '1';
Result(Result.count).tname := 'name1';Result.extend;
Result(Result.count) := CTEST(NULL,NULL);
Result(Result.count).tid := '2';
Result(Result.count).tname := 'name2';
return(Result);
end myTest;
/select *
from table(cast(myTest as tabctest))