VIEW: SYS._ALL_FILE_GROUP_VERSIONS

Source

View Text - Preformatted

select g.file_group_owner, g.file_group_name, v.version_name, v.version_id,
       v.version_guid, v.creator, v.creation_time, v.user_comment,
       v.default_dir_obj
from "_ALL_FILE_GROUPS" g, sys.fgr$_file_group_versions v
where g.file_group_id = v.file_group_id

View Text - HTML Formatted

SELECT G.FILE_GROUP_OWNER
, G.FILE_GROUP_NAME
, V.VERSION_NAME
, V.VERSION_ID
, V.VERSION_GUID
, V.CREATOR
, V.CREATION_TIME
, V.USER_COMMENT
, V.DEFAULT_DIR_OBJ FROM "_ALL_FILE_GROUPS" G
, SYS.FGR$_FILE_GROUP_VERSIONS V WHERE G.FILE_GROUP_ID = V.FILE_GROUP_ID