How to compile SQL in Oracle SQL Developer?

Question

I have a SQL query that has error.

When I execute it i get ORA-00942: Table or view does not exist.

I don't know which table is giving me the error.

I do know that some SQL Editors offer compilation of SQL and highlight the part that has error. is it possible in oracle sql developer?

Sathyajith Bhat · Accepted Answer · 2011-01-19 12:32:54Z

2

Try the ye ol' Oracle SQL*Plus

SQL> select * from dasd
  2  union 
  3  select 1 from dual
  4  /
select * from dasd
              *
ERROR at line 1:
ORA-00942: table or view does not exist

If you want to know if it's possible in SQL developer - it depends. If it's a stored procedure, double-clicking on the error message in the Log -> Compiler messages should show the approximate location of the error. If you're running in SQL Worksheet, then unfortunately, it's not possible.

answered Jan 19, 2011 at 12:32

Sathyajith Bhat

22k22 gold badges102 silver badges141 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to compile SQL in Oracle SQL Developer?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related