Link to home
Start Free TrialLog in
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;
User generated image
Avatar of slightwv (䄆 Netminder)
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.
Avatar of 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
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chima

ASKER

Got you, thanks