Hi there,
SQL Editor it´s really cool. the auto completion feature is one of my favorites. Actually, I´ve noticed that to use completion you need to informa a table name before showing the fields. Seems logical, of course, but I have a a sugestion. Today, SQL works this way
select TABLE_NAME.field1,TABLE_NAME.field2,TABLE_NAME.field3 from TABLE_NAME
I think you define a alias could help, like this…
First step (when editing a query)
========
SELECT * from TABLE_NAME ALIAS
Second Step (change * for the fields you want, using the alias. a short one, heheheh)
SELECT ALIAS.field1,ALIAS.field2,ALIAS.field3 from TABLE_NAME ALIAS
This kind of feature is available in Toad 7.6 (Quest software) ans it´s really cool, elegant and faster…
Just a sugestion…. 🙂
Thanks in advance,
Clayton Fonseca
Brazil