- 论坛徽章:
- 0
|
代码:--------------------------------------------------------------------------------
create or replace type Permission as object
(
pid integer,
oid integer,
pvalue char(1),
ptrans char(1)
)
CREATE OR REPLACE TYPE PERMISSION_LIST AS TABLE OF Permission
CREATE OR REPLACE TYPE MyBio AS OBJECT
(
userid integer,
username varchar2(20),
plist permission_list
)
CREATE TABLE TEST_USER OF MYBIO
NESTED TABLE PLIST STORE AS NESTED_PERMISSION_LIST
--------------------------------------------------------------------------------
在PHP5中执行SQL语句select * from test_user t无法返回任何结果,结果集是false,不知道在PHP5中要如何才能取回嵌套表的结果集?
P.S 代码测试过简单表没有问题 |
|