How to turn on table name autocomplete feature in Toad?

Question

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??

Andrea · Answer 1 · 2014-01-15T10:30:28.697

61

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"

edited Jan 15 '14 at 10:30

answered Jul 17 '13 at 12:52

Andrea

1

Thanks! This works for other stuff, not just tables! Amazing! – AnimNations Nov 08 '17 at 15:14
1

Jesus christ the years wasted I've been using toad and never thought to try that! – codinglifestyle May 03 '19 at 07:57
Something that must be known by the world. – Jean Jimenez Mar 16 '23 at 14:00

score 26 · Answer 2 · edited Feb 26 '18 at 04:34

26

As an alternative you can press Ctrl + T

edited Feb 26 '18 at 04:34

dwurf

answered Sep 24 '14 at 08:17

Tobias

score 2 · Answer 3 · answered Apr 01 '15 at 18:44

2

Try setting a default schema: Toad Options > Oracle > General > Default Schema.

answered Apr 01 '15 at 18:44

Steve

3 Answers3