Question

在以下法典例中:

Type single_table_purge_type is varray(2) of varchar2(255);
Type single_table_list is table of single_table_purge_type; 

purge_table single_table_list;

purge_table := new single_table_list(
            new single_table_purge_type( product , Where product_id=5 ),
            new single_table_purge_type( customer , Where customer_id=10 )
);

For x in 1..purge_table.Count
        Loop
            For y in 1..purge_table(x).Count
            Loop
                DBMS_OUTPUT.put_line(  x= ||x||  y= ||y||  cell= ||purge_table(x)(y));
            End loop;
        End loop;

DBMS_OUTPUT.put_line(  m1   || purge_table(1)(1));
DBMS_OUTPUT.put_line(  m2   || purge_table(1)(2));
DBMS_OUTPUT.put_line(  m3   || purge_table(2)(1));
DBMS_OUTPUT.put_line(  m4   || purge_table(2)(2));

How can i get to the items (1,2) or (2,2)? (i.e. the where clauses). All i see is a duplicate of the first item when i print the values out.

产出

m1 product
m2 product
m3 customer
m4 customer

Answer 1

如所示(declare,begin,和end),我以Oracle 10g为题:

x=1 y=1 cell=product
x=1 y=2 cell=Where product_id=5
x=2 y=1 cell=customer
x=2 y=2 cell=Where customer_id=10
m1 product
m2 Where product_id=5
m3 customer
m4 Where customer_id=10

这使我相信,你在把你所展示的东西混为一谈方面有些错误。请问你,在你管理时,如何准确地提供文字。

(这确实应当是评论,但需要长篇和格式,使之适合。)

友情链接