starting from Oracle 12cR2 you need to configure password file to change SYS account password. as you know when accessing the database as software owner (OS authentication), no need for password to Read More

SELECT AGILE.ITEM.ITEM_NUMBER, AGILE.REV.REV_NUMBER, AGILE.FILES.FILENAME, AGILE.FILES.CONTENT_URL, AGILE.REV.LATEST_FLAG FROM AGILE.ATTACHMENT_MAP INNER JOIN AGILE.VERSION_FILE_MAP ON AGILE.ATTACHMENT_MAP.LATEST_VSN = AGILE.VERSION_FILE_MAP.VERSION_ID INNER JOIN AGILE.FILES ON AGILE.VERSION_FILE_MAP.FILE_ID = AGILE.FILES.ID INNER JOIN AGILE.ITEM ON AGILE.ATTACHMENT_MAP.PARENT_CLASS = AGILE.ITEM.CLASS AND Read More