Hi,
I have the DDL script to create a view and I am executing it in a worksheet. I see the "Table/view does not exist error". That is fine. I am probably missing a grant.
Is there a way for SQL Developer to show me/highlight the line number on which the error occurred?
Instead of using the worksheet, I also tried this: Connection tree -> schema -> View - > right-click -> New View/ Create Simple.
This asks me to enter the view name and the select statement separately. I'm looking for a way to execute the entire script I have and also see what line numbers the error is on.
Thank you!
Edit: I tried the "Create View" utility now. I paste my select statement and hit "Test" or "Check Syntax". I see "Syntax Error at line 115". But the utility (the popup for Create View) doesn't show line numbers