toad for oracle autocomplete dropdown

oracle plsql toad
Raj More picture Raj More · Dec 26, 2010 · Viewed 28.4k times · Source

Toad for Oracle has an autocomplete feature.. you type SELECT * FROM USER. and then press Ctrl+. and a drop down appears where you can choose from the objects available to you.

This functionality suddenly stopped. Now, instead of a drop down, it goes to the first default match. I have no idea what I did to change the behavior.

How do I restore the drop down functionality?

Answer

Craig picture Craig · Dec 29, 2010

This option is under Options -> Editor -> Code Assist. The only time I have ever seen it autofill instead of providing a list is when there is only one table that matches though... What version of Toad are you using?

Related questions

Simple Oracle variable SQL Assignment

Despite having spent an hour researching I can't seem to figure out how to correctly define a variable and then use it in your SQL. This is what I have so far produced: DECLARE startDate DATE := to_date('03/11/2011', …

Read More
ORA-00932: inconsistent datatypes: expected - got -

I have been using Oracle(10g.2) as a PHP programmer for almost 3 years, but when I gave an assignment, I have tried to use the ref cursors and collection types for the first time. And I 've searched the web, …

Read More
Display results in output parameter in Toad

I have a stored procedure in Oracle and I'm using an out parameter in it.. I want to know how to display the output in Toad..

Read More