I have certain synonyms in my schema which represent views from another schema. Now in oracle sqldeveloper, I am unable to see the actual SQL for those views but I see only an SQL like:
CREATE OR REPLACE SYNONYM "ABC"."ABC_CHAR" FOR "XYZ"."ABC_CHAR";
Now my question is: is there a way for me to see the Actual SQL for the View
XYZ.ABC_CHAR that is in the other schema?