This content has been marked as final. Show 10 replies
you can use the SQL*Plus CONN[ECT] command - we support that in the worksheet.
Just right-click Connections, choose "[plus] New Connection" ... then fill in the information and test it.
(I have 6 DBs ... I have a connect to all of them, plus a few several times, as different users / schemas, for link-testing purposes ... you can then export the connections as an XML file ... share that with others (who then import it))
Or just use the connection dropdown in the upper right hand corner of the worksheet to change the connection.
I originally read the question as they were looking for a way to programmatically change the connection vs UI.
Thanks for your replies.
I have already added them as new connection, but i don't want to take that route of clicking on the connection instance and opening a new sql worksheet after successful connection; rather i would prefer accessing all the instances from the same sql worksheet which how i used to do it on SQL*PLUS.
I tried executing the following command on sql worksheet: sqlplus connect username/password@instance
but it ain't working.
The connection dropdown property will change the connection for the current worksheet, no new worksheet is opened.
If you're going to run a SQL*Plus command, just type the command, no need to add the 'sqlplus' bit.
Without using the connection dropdown option, is there any other way i can connect?
I used CONNECT USERNAME/PASSWORD@INSTANCE on sql developer worksheet and it's not working.
type 'CONNECT', hit ctrl-enter, and then follow the prompts
No luck. It says "Invalid SQL Statement".
I am on Version 1.5.5. Is that an issue?
It's not an issue if you're happy to be living in the year 2006 :)
The latest and greatest version of SQL Developer is 3.2.20_09 and we didn't add support for CONNECT in the worksheet until way after 1.5
Except for speed, latest and greates is definitely better than earlier versions!!