SYSPUBLICATIONS system view

CREATE VIEW SYS.SYSPUBLICATIONS
AS 
SELECT(select user_name FROM SYS.SYSUSERPERM AS u
	WHERE u.user_id=p.creator) AS creator,
	publication_name,remarks 
FROM SYS.SYSPUBLICATION AS p

Presents the user name from the SYSUSERPERM table for all creators, and displays the publication name and remarks from the SYSPUBLICATION table in a readable format.