asked on
Oracle SQL Developer Column Ruler
Hello,
Does the SQL Developer tool have a way of applying a "column ruler" at the top a a SQL statement?
When I create a statement and it has some error; the tool gives me a line and column. The line and column at the lower right corner is not accurate, it is 10 spaces short and it does count the spaces between words;
![Header Ruler]()
Does the SQL Developer tool have a way of applying a "column ruler" at the top a a SQL statement?
When I create a statement and it has some error; the tool gives me a line and column. The line and column at the lower right corner is not accurate, it is 10 spaces short and it does count the spaces between words;
Oracle DatabaseDatabases
Last Comment
chima
ASKER
slightwv, good observation. At least knowing this will be helpful in narrowing down the location. I guess a column is considered to be the "table column"
Thanks
Thanks
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Got you, thanks
For example, a missing parenthesis might generate an error far from where the actual problem is.
Anyway: If I counted right, column 58 is the starting character of the invalid object: ti.ISO_NAMmE.
Oracle has no way to know that it is the second 'm' that makes the column invalid. It just knows what column isn't in the referenced table.