Avatar of chima
chima
 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
Oracle DatabaseDatabases

Avatar of undefined
Last Comment
chima

8/22/2022 - Mon
slightwv (䄆 Netminder)

I've never found the line and column in the error to be all that accurate.

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.
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
ASKER CERTIFIED SOLUTION
slightwv (䄆 Netminder)

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.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
chima

ASKER
Got you, thanks
Your help has saved me hundreds of hours of internet surfing.
fblack61