5 Replies Latest reply on May 19, 2014 2:31 PM by thatJeffSmith-Oracle

connecting to database

Eslam_Elbyaly May 19, 2014 1:24 PM

hi al l,

it is the first time i use sql developer , i downloaded version Version 4.0.2.15 build 15.21 ,downloaded the jdk ,

and it works fine , but i can not connect to the database ,

- we have the database(exsys11) installed on a server ,

- i installed sql developer on my client .

- i copied "tnsnames.ora" and "sqlnet" to the sql developer folder ,

but it can not see the databases .

i connected using a username and a password , and a connection type of "tns" and Role = default ,

but it can not see my databases ???

thanks

1. Re: connecting to database

thatJeffSmith-Oracle May 19, 2014 1:42 PM (in response to Eslam_Elbyaly)

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.
Like Show 0 Likes(0)

Actions
2. Re: connecting to database

Eslam_Elbyaly May 19, 2014 2:09 PM (in response to thatJeffSmith-Oracle)

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 ?!
Like Show 0 Likes(0)

Actions
3. Re: connecting to database

thatJeffSmith-Oracle May 19, 2014 2:13 PM (in response to Eslam_Elbyaly)

auto-completion of what and where?
Like Show 0 Likes(0)

Actions
4. Re: connecting to database

Eslam_Elbyaly May 19, 2014 2:16 PM (in response to thatJeffSmith-Oracle)

i am selecting data from rc_patients table .
i wrote
select * from rc
it should autocomplete with all table names which starts with "rc" , and it does not .
Like Show 0 Likes(0)

Actions
5. Re: connecting to database

thatJeffSmith-Oracle May 19, 2014 2:31 PM (in response to Eslam_Elbyaly)

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:
http://www.thatjeffsmith.com/archive/2014/05/video-completion-insight-in-oracle-sql-developer-v4-0-2

In the future, please start new threads for each new question.
Like Show 0 Likes(0)

Actions

Go to original post