How to turn on table name autocomplete feature in Toad?

toad
star09 picture star09 · Jun 18, 2013 · Viewed 44k times · Source

I'm using Toad version 11.0.0.116. I'm not getting default tablename options when I start typing table. How to turn the autocomplete feature on??

Answer

Andrea picture Andrea · Jul 17, 2013

Pressing Ctrl + . should show you a list of available tables.

For example typing:

SELECT * FROM U

and then pressing Ctrl + . should show you a list of all the tables starting with "U"

Related questions

ORA-12170: TNS:Connect timeout occurred

I was trying to connect to the database here in my laptop using Oracle Toad but I kept on having this error: ORA-12170: TNS:Connect timeout occurred What are the possible reasons why I kept on having this error? I …

Read More
How can I solve ORA-00911: invalid character error?

I tried to execute an SQL INSERT with Toad for oracle: INSERT INTO GRAT_ACTIVITY (UUID, IP_ADRESS, SEND_MAIL, DATE_CREA, DATE_UPD, CREATOR, CENTER, ETAT, REQUEST) VALUES('555-vgd9-pllkd-5513', '172.12.23.130', 'N', SYSDATE, SYSDATE, '1554', …

Read More
Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

Is there a workaround for 'ORA-01795: maximum number of expressions in a list is 1000 error' I have a query and it is selecting fields based on the value of one field. I am using the in clause and there are 10000+ …

Read More