在APEX集合中只显示10个字段,可以使用以下代码示例来解决:
DECLARE
l_collection_id NUMBER;
BEGIN
l_collection_id := apex_collection.create_collection(p_collection_name => 'MY_COLLECTION');
END;
BEGIN
apex_collection.create_or_truncate_collection(p_collection_name => 'MY_COLLECTION');
apex_collection.add_member(
p_collection_name => 'MY_COLLECTION',
p_c001 => 'Value1',
p_c002 => 'Value2',
p_c003 => 'Value3',
p_c004 => 'Value4',
p_c005 => 'Value5',
p_c006 => 'Value6',
p_c007 => 'Value7',
p_c008 => 'Value8',
p_c009 => 'Value9',
p_c010 => 'Value10'
);
END;
SELECT c001, c002, c003, c004, c005, c006, c007, c008, c009, c010
FROM apex_collections
WHERE collection_name = 'MY_COLLECTION';
请注意,在上述示例中,我们使用了APEX_COLLECTION包中的函数来创建和管理集合。你需要确保你的数据库用户有权访问APEX_COLLECTION包。