Tools > Preferences > Database > Advanced
In the last bit, Tnsnames Directory, put in your sqldev folder where you copied the tnsnames file to.
This is assuming changing your connection type 'Basic' to 'TNS' and accessing the 'Network Alias' drop-down control doesn't already show you your tns entries.
damn , there is no autocompletion ? !!
i do not know why oracle does this , why is not there autocompletion in some tools ,
it did it in jdeveloper , why is not it in all other tools ?!
auto-completion of what and where?
i am selecting data from rc_patients table .
select * from rc
it should autocomplete with all table names which starts with "rc" , and it does not .
Do you have more than 10 objects that start with rc?
If so, you need to hit ctrl+spacebar to invoke the completion. Here's a quick writeup and video showing how it works:
In the future, please start new threads for each new question.