The view has been created with the following statement. It all seems to work but there is no data there - do I need to specify the string?? Not sure what I’m doing here??
CREATE OR REPLACE FORCE VIEW NEW_VIEW_VW ( URL, ORGANISATION, CATEGORY, SEARCH_1, SEARCH_2 ) AS SELECT DISTINCT, TABLE1.SERV_URL, TABLE2.ORGANISATION, TABLE1.SEARCH_1, TABLE1.SEARCH_2 FROM TABLE1, TABLE2; CREATE PUBLIC SYNONYM NEW_VW; DROP PUBLIC SYNONYM NEW_VIEW_VW; CREATE PUBLIC SYNONYM NEW_VIEW_VW; GRANT SELECT ON NEW_VIEW_VW;