问题起源:http://www.itpub.net/628185.html
对于ARRAY字段类型的数据操作
CREATE TYPE ARRAY_LINK AS ARRAY(100) OF NUMBER(15,0);
/
CREATE TABLE TEST (ID NUMBER(10), LINKS ARRAY_LINK);
/
INSERT INTO TEST(ID,LINKS) VALUES(1,ARRAY_LINK(11,111));
/
INSERT INTO TEST(ID,LINKS) VALUES(2,ARRAY_LINK(22,222,2222));
/
COMMIT;
不知道要怎么SELECT才能得到如下结果:
ID LINK_MEMBER
1 11
1 111
2 22
2 222
2 2222
解答:
CREATE or replace TYPE ARRAY_LINK AS ARRAY(100) OF NUMBER(15,0);
/
CREATE TABLE TEST3 (ID NUMBER(10), LINKS ARRAY_LINK);
INSERT INTO TEST3(ID,LINKS) VALUES(1,ARRAY_LINK(11,111));
INSERT INTO TEST3(ID,LINKS) VALUES(2,ARRAY_LINK(22,222,2222));
COMMIT;
select id,column_value from test3 a,table(select links from test3 where id=a.id) b;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9279504/viewspace-997131/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9279504/viewspace-997131/