Re: Q] CAST-MULTISET usage in Oracle8i ?

From: Lars Bo Vanting, COREBIT TPI <lbv_at_vanting.com>
Date: Thu, 2 Sep 1999 14:10:28 +0200
Message-ID: <7qlpmf$d1$1@news1.sunrise.ch>

Here's a simple example using the EMP table an selecting into a VARRAY object type with 500 elements:

set serverout on
drop type EMP_RECORD_LIST_T;
drop type EMP_RECORD_T;
create or replace
  TYPE EMP_RECORD_T AS OBJECT
  (

   EMPNO                                                 NUMBER(4),
   ENAME                                                 VARCHAR2(10),
   JOB                                                   VARCHAR2(9),
   MGR                                                   NUMBER(4),
   HIREDATE                                              DATE,
   SAL                                                   NUMBER(7,2),
   COMM                                                  NUMBER(7,2),
   DEPTNO                                                NUMBER(2)

  );
/
CREATE OR REPLACE TYPE EMP_RECORD_LIST_T AS VARRAY (500) OF EMP_RECORD_T; /
declare
  EmpList EMP_RECORD_LIST_T;
Begin
  select cast(multiset(select * from scott.emp order by empno) AS EMP_RECORD_LIST_T )
  into EmpList
  from dual;
  For i in EmpList.first..EmpList.last loop     dbms_output.put_line('EmpNo '||to_char(EmpList(i).empno)||' = '||EmpList(i).ename);
  end loop;
End;
/

Regards
Lars Bo Vanting
COREBIT SYAP/TPI AG, Switzerland

ksjune <ksjune_at_sys.gsnu.ac.kr> wrote in message news:37CE35CB.AB9F0A6F_at_sys.gsnu.ac.kr...
> Hi there....
> How can I use CAST-MULTISET?
> I read SELECT section in SQL References. But I do not understand.
> And there is small piece of samples.
> Anybody teach me.
>
> Thanks in Advance....
>
> mailto:ksjune_at_sys.gsnu.ac.kr
>
Received on Thu Sep 02 1999 - 07:10:28 CDT