Oracle：查询用户定义类型的值
我有一个用户定义的类型：
create or replace type my_message_type
as object (relatedid varchar2(50), payload clob);
SYNESSO.MY_MESSAGE_TYPE('abcdefgh','oracle.sql.CLOB@1dae16a')
select count(1) from table_of_my_messages where user_data.relatedid = 'abcdefgh';
ORA-00904: "USER_DATA"."RELATEDID": invalid identifier
any
select * from table_of_my_messages where user_data = my_message_type('abcdefgh', *);
-- ORA-00936: missing expression
select * from table_of_my_messages where user_data = my_message_type('abcdefgh');
-- ORA-02315: incorrect number of arguments for default constructor
select * from table_of_my_messages where user_data = my_message_type('abcdefgh', ?);
-- Missing IN or OUT parameter at index:: 1
没有找到相关结果
已邀请:
1 个回复
响摔衅幸
select count(1) from table_of_my_messages m where m.user_data.relatedid = 'abcdefgh';